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

  1. Log in to the management console.
  2. Click in the upper left corner and select a region.
  3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
  4. On the Instances page, click the primary instance name.
  5. 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

  6. On the Overview page, check for the new replication mode.