You can upgrade the synchronization topology of a data synchronization task from one-way to two-way in the Data Transmission Service (DTS) console.

Prerequisites

  • The types of source and destination databases of the data synchronization task are both MySQL.
  • The synchronization topology of the data synchronization task is one-way synchronization.
  • The status of the data synchronization task is Running.

Limits

  • 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.
  • The upgrade operation causes data synchronization latency of about 5 seconds. We recommend that you perform this operation during off-peak hours.
  • When DTS runs a two-way data synchronization task, DTS creates a database named dts in the destination database to prevent circular synchronization. Make sure that the destination database has the read and write permissions on the dts database.

Billing

  • Subscription instance
    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 instance

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

For more information about the pricing of DTS, see Billing overview.

Procedure

  1. Go to the Data Synchronization Tasks page.
    1. Log on to the DMS console.
    2. In the top navigation bar, click DTS.
    3. In the left-side navigation pane, choose DTS (DTS) > Data Synchronization.
  2. From the drop-down list to the right of Data Synchronization Tasks, select the region in which your data synchronization instance resides.
    Note If you use the new DTS console, select the region in which your data synchronization instance resides in the top navigation bar.
  3. In the Actions column of the instance, click the More icon and select Change to Two-way.
  4. Click OK.
  5. Configure the data synchronization task in the reverse direction.