Changing the AZ of a Standby DB Instance

Updated on 2024-03-05 GMT+08:00

View PDF

You can migrate a standby DB instance to another AZ in the same region as the original AZ.

Primary/standby instances running MySQL 5.6, 5.7, or 8.0 support standby instance migration to another AZ.
Batch write operations during peak hours may cause migration failures. To ensure successful migration, perform the migration during off-peak hours.
DDL operations and scheduled events will be suspended during migration. To prevent service interruptions, perform the migration during off-peak hours.

Log in to the management console.
Click in the upper left corner of the page and choose Databases > Relational Database Service.
On the Instances page, locate the target DB instance and choose More > Migrate Standby DB Instance in the Operation column.
On the displayed page, select a target AZ and click Submit.
Check the DB instance status on the Instances page.
- During the migration process, the DB instance status is Migrating standby DB instance. You can view the progress on the Task Center page. For details, see Task Center.
- In the upper right corner of the DB instance list, click to refresh the list. After the migration is complete, the DB instance status will become Available.
- In the DB Information area on the Basic Information page, you can view the AZ hosting the standby DB instance.