MySQL RDS Replica Promotion Stuck in "Backing-Up" State

0

Good evening,

We are in the middle of upgrading one of our RDS instances from MySQL 5.6 to MySQL 5.7. To minimize downtime, we took the path of creating a replica, upgrading that replica to 5.7, and then promoting it to the primary. The issue is after we selected to promote the database, its stuck in "Backing Up" state and has been for the past hour. Before the promotion, we placed the primary instance into "Read Only" mode via a parameter group setting.

There is no indication that anything is happening, and the log files aren't updating either. The DB instance itself is still responsive to traffic.

Is this normal? AWS documentation said the promotion process would take "a few minutes". Snapshots/backups on our current production database only take about 2 minutes to complete...

1개 답변
1
수락된 답변

backing-up state means the database is available but it is taking a snapshot. So maybe the promotion is already done and the database is available for use. The replicas normally do not have backups enabled and it is mandatory for primaries to have them, so once a replica gets promoted it starts taking a backup, and this operation can take time as the first backup needs to copy the entire disk snapshot. backing-up instances are usable but not modifiable in AWS console.

After the first snapshot, the rest of them are faster, like in your production database, because consecutive snapshots only copy the disk differences between snapshots.

I've found that sometimes enabling backups and taking a manual snapshot of the replica meant to be promoted before the promotion speeds up any automated backup created later, but YMMV.

theist
답변함 2년 전
  • Thanks a ton for the context and how you generally approach these things! I'll definitely give that a try on the next one as I have several to do. The job did end up completing, it just took about an hour or hour 20. Otherwise it was a fairly seamless process! I've definitely accepted your answer. Thanks again!

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인