• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. User Guide
  4. Managing DB Instances
  5. DB Instance Operations
  6. Manually Switching Between Primary and Standby DB Instances

Manually Switching Between Primary and Standby DB Instances

Scenarios

If you choose to create primary/standby DB instances, RDS will create a primary DB instance and a synchronous standby DB instance in the same region. You can access only the primary DB instance. The standby instance serves as a backup. If the primary DB instance is faulty, the standby DB instance is promoted to the new primary instance and takes over services for failover support.

Prerequisites

  1. A DB instance is running properly.
  2. The replication relationship between the primary and standby instances is normal.

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 to go to the RDS console.
  4. On the Instance Management page, locate the target primary/standby DB instance and click the DB instance name.
  5. On the Basic Information page, click Switch in the DB Instance Type field in the Instance Information area.
  6. In the Switch Primary/Standby DB Instance dialog box, click OK to switch between the primary and standby DB instances.

    If the replication status is Available and the replication delay is greater than 300s, the primary/standby switchover task cannot be delivered.