Switch mster/slave instance

Last Updated: Dec 11, 2017

When the RDS instance is created successfully, the system automatically creates a free slave instance for it in the same region as that of the master instance. But the slave instance is located in a different zone (random assignment) from that of the master instance.

The data in the master instance synchronizes to the slave instance in real time. You can only access the master instance. The slave instance exists only as a backup. However, when the rack where the master instance is located encounters an error, the master and slave instances can be switched. After the handover, the original master instance becomes a backup instance, and the rack-level disaster tolerance can be realized.

This article describes how to switch the master/slave instance.

Attentions

  • Currently this operation is not applicable to MySQL 5.7 and SQL Server 2012 instances. Since they are basic single node edition instances, and they do not have slave node.

  • Switching the master/slave instance may result in transient disconnection. Make sure that your application has a reconnection policy.

Procedure

  1. Log on to the RDS console.

  2. Select the region where the target instance is located.

  3. Click the ID of the target instance to visit the Basic Information page.

  4. In the left-side navigation pane, select Instance Availability.

  5. In the Availability Information area, click Switch Master/Slave Instance, as shown in the following figure.

    Switch master or slave instance

  6. Click Confirm to switch the instance.

Thank you! We've received your feedback.