This topic describes how to change the data replication mode of an RDS for MySQL instance and its slave instance to improve service availability
This function is available to the High-availability Edition of MySQL 5.5, 5.6, and 5.7.
Overview of data replication
The updates initiated from your application are performed on the master RDS instance. Then the corresponding logs are synchronized to the slave RDS instance. The system regards that the transactions are submitted before the updates recorded in the logs are performed on the slave RDS node.
If the slave RDS instance is unavailable or communication between the master and slave RDS instances is abnormal, the semi-synchronous data replication mode is degraded to the asynchronous data replication mode.
When your application initiate an update request for adding, deleting, or modifying data, the master RDS instance responds to your application immediately and replicates data to the slave RDS instance asynchronously after completing the requested operation. Therefore, in asynchronous data replication mode, the operations on the master RDS instance are not affected even when the slave RDS instance is unavailable. Additionally, the probability that data inconsistencies are incurred by unavailability of the master RDS instance is low.
The DB engine version and edition are one of the following:
- MySQL 8.0 High-availability Edition (with local SSDs)
- MySQL 5.7 High-availability Edition (with local SSDs)
- MySQL 5.6 High-availability Edition
- MySQL 5.5
- Log on to the RDS console.
- In the upper-left corner, select the region where the target RDS instance is located.
- Find the target RDS instance and click the instance ID.
- In the left-side navigation pane, click Service Availability.
- In the Availability Information section, click Change Data Replication Mode.
- In the displayed dialog box, select a data replication mode and click OK.
|ModifyDBInstanceHAConfig||Used to change the HA mode and data replication mode of an RDS instance.|