Modifying the Data Replication Mode
Last updated: 2025-12-03 11:54:29
TencentDB for MySQL supports the following data replication modes: asynchronous replication, semi-synchronous replication, and strong synchronous replication. You can set the data replication mode of TencentDB for MySQL instances based on business characteristics during instance creation to improve TencentDB availability. You can modify the data replication mode through the console after an instance is created. This document describes how to modify the data replication mode of an instance through the console.
Note:
For the definitions and differences of the above data replication modes, see Database Instance Replication.
Prerequisites
The instance architecture is two-node, three-node, or Cluster Edition.
The instance is running, and no other tasks are being executed.
Support for Different Modes
Database Version | Supported Data Replication Mode |
MySQL 5.5 | Asynchronous Replication |
MySQL 5.6 MySQL 5.7 MySQL 8.0 | Asynchronous Replication |
| Semi-synchronous Replication |
| Strong Synchronous Replication |
Instance Architecture | Supported Data Replication Mode |
Single-node | Do not support setting or modifying the data replication mode |
Two-node Cluster Edition | Asynchronous Replication |
| Semi-synchronous Replication |
Three-node | Asynchronous Replication |
| Semi-synchronous Replication |
| Strong Synchronous Replication |
Operation Steps
Querying the Data Replication Mode
1. Log in to the MySQL console and click Instance ID or Manage in the Operation column in the instance list to go to the instance details page.
2. Choose Instance Info > Data Replication, and query the current data replication mode of the instance.
Modifying the Data Replication Mode
1. Log in to the MySQL console and click Instance ID or Manage in the Operation column in the instance list to go to the instance details page.
2. Choose Instance Info > Data Replication, and click the edit icon.
3. Select the target data replication mode in the pop-up window and click Submit.
4. If the data replication mode remains unchanged, the message "The configuration of the instance has not changed. Please check" is prompted. You need to select a different data replication mode and submit again.
5. The modification is successful when the instance running status changes from "Changing configuration" to "Running" after a successful submission.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback