Updated on 2022-08-16 GMT+08:00

Migrating a Standby DB Instance

Scenarios

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

  • Only primary/standby DB instances running MySQL 5.6 or 5.7 support standby DB instance migration to another AZ. DB instances whose storage type is local SSD cannot be migrated.
  • DDL operations and scheduled events will be suspended during migration. To prevent service interruptions, perform the migration during off-peak hours.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service. The RDS console is displayed.
  4. On the Instance Management page, locate the target DB instance and choose More > Migrate Standby DB Instance in the Operation column.
  5. On the displayed page, select a target AZ and click Submit.
  6. After the migration is complete, you can view and manage the DB instance on the Instance Management 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 section 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 on the Basic Information page, you can view the AZ hosting the standby DB instance.