Help Center/ Relational Database Service/ Best Practices/ RDS for MySQL/ Configuring Remote Single-Active DR for an RDS for MySQL Instance Using DRS/ Configuring Remote Disaster Recovery/ Performing a Primary/Standby Switchover
Updated on 2024-09-30 GMT+08:00
View PDF
Share

Performing a Primary/Standby Switchover

If the source database in the production center is faulty, manually switch the DR instance to the read/write state. Then, data is written to the DR instance and synchronized to the source database.

Procedure

  1. Find that the source database in the production center is faulty. For example, the source database cannot be connected, the source database execution is slow, or the CPU usage is high.
  2. Receive an SMN email notification.
  3. Check the delay of the DR task.
  4. Check that the services of the source database have been stopped. For details, see How Do I Ensure that All Services on the Database Are Stopped?
  5. Select the task, click the Batch Operations drop-down box in the upper left corner and select Primary/Standby Switchover.

    Figure 1 Primary/standby switchover

  6. Change the database IP address on your application and use it to connect to the database. Then data is properly read from and written to the database.
Parent Topic: Configuring Remote Disaster Recovery