Help Center/
Relational Database Service/
User Guide/
Working with RDS for MySQL/
Instance Management/
Instance Modifications/
Changing the Replication Mode
Updated on 2024-10-14 GMT+08:00
Changing the Replication Mode
Scenarios
You can change the replication mode for primary/standby DB instances to Asynchronous or Semi-synchronous.
- Asynchronous:
- When applications update data, the primary DB instance responds to the applications immediately after data is updated. This mode provides better performance than the semi-synchronous mode.
- Semi-synchronous (default value):
- When applications update data, the primary DB instance responds to the applications only after the standby DB instance receives logs, which affects database performance.
- If the standby DB instance is abnormal, the primary DB instance waits for the response of the standby DB instance for several seconds and does not respond to write operations during this period.
- If the standby DB instance is recovered during the waiting period, the primary DB instance starts to respond to write operations normally.
- If the standby DB instance is not recovered during the waiting period, the replication mode is automatically switched to asynchronous. After the switchover is complete, the primary DB instance starts to respond to write operations.
Procedure
- Log in to the management console.
- Click in the upper left corner and select a region.
- Click in the upper left corner of the page and choose Databases > Relational Database Service.
- On the Instances page, click the primary instance name.
- On the displayed Overview page, find Replication Mode and click Configure under it. In the displayed dialog box, select a mode and click OK.
Figure 1 Changing the replication mode
- On the Overview page, check for the new replication mode.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot