Upgrade synchronization topology from one-way to two-way

Prerequisites

The following conditions must be met when you upgrade synchronization topology from one-way to two-way:

• A instance to be upgraded is one-way synchronization topology, that is, Synchronization Topology is One-way Synchronization.

• The types and versions of source database and destination database of the instance to be upgraded are compatible with that of two-way synchronization instance. For example, the source database and destination database of the instance run MySQL 8.0.

  For more information, see Supported instances section of this topic and Overview of data synchronization scenarios.

• The Status of the instance to be upgraded is Running.

• The destination database of the instance to be upgraded has the required permissions.

  For more information, see Permissions of destination database account section of this topic.

Supported instances

Permissions of destination database account

Billing

• Subscription method

  Total fee for upgrading a subscription instance = (Daily fee of the instance after upgrade - Daily fee of the instance before upgrade) × (Subscription expiration date - Upgrade date)

  Note

  The daily fee of an instance after upgrade depends on the number of remaining days from the upgrade date to the expiration date.

  • If the number of remaining days is less than 300 days, the daily fee of the instance after upgrade equals the monthly subscription price divided by the number of days in the month.

  • If the number of remaining days is greater than or equal to 300 days, the daily fee of the instance after upgrade equals the yearly subscription price divided by the number of days in the year.

• Pay-as-you-go method

  After you upgrade a pay-as-you-go instance, you are charged per hour based on the new instance class.

Usage notes

• You can only upgrade the synchronization topology from one-way to two-way. You cannot downgrade the synchronization topology from two-way to one-way.

• You cannot upgrade the synchronization topology from one-way to two-way for a data synchronization task between PolarDB-X 2.0 instances.

Procedure

1. Use one of the following methods to go to the Data Synchronization page and select the region in which the data synchronization instance resides.

   DTS console

   DMS console

   1. Log on to the DTS console.

   2. In the left-side navigation pane, click Data Synchronization.

   3. In the upper-left corner of the page, select the region in which the data synchronization instance resides.

   Note

   The actual operations may vary based on the mode and layout of the DMS console. For more information, see Simple mode and Customize the layout and style of the DMS console.

   1. Log on to the DMS console.

   2. In the top navigation bar, move the pointer over Data + AI and choose DTS (DTS) > Data Synchronization.

   3. From the drop-down list to the right of Data Synchronization Tasks, select the region in which the data synchronization instance resides.

2. Find the destination instance.

3. Choose > Change to Two-way at the Actions column of the destination instance.

4. Click OK in the dialog box. The upgrade of the data synchronization instance is completed.

   After the instance upgrade is completed, a data synchronization instance in the reverse direction that is Not Configured appears in the lower part of original data synchronization instance.

5. Configure the data synchronization instance in the reverse direction based on your business requirements.