Switch master/slave instance

Last Updated: Mar 02, 2018

Once the RDS instance is created successfully, the system automatically creates a free slave instance for it. The slave instance is located in the same region, where the master instance is located, but in a different zone.

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 document describes how to switch the master/slave instance.

Attention

  • Currently this operation is not applicable to the Basic Edition of MySQL 5.7 and SQL Server 2012/2016 instances. This is because Basic Edition instances do not have slave nodes.

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

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.