Data Transmission Service:Modify the objects to be synchronized

Prerequisites

• The data synchronization task starts to write incremental data. The task is in the Running state or fails to synchronize data.Incremental Write

• The source and destination databases are not in the process of upgrade, configuration change, network switchover, or cross-zone migration when you modify the objects to be synchronized. This ensures that DTS can connect to the source and destination databases. This also ensures that DTS can read database and table information from the source database.

• The latency of the data synchronization task is less than 10 minutes.

Usage notes

• If a data synchronization task has an Incremental Write module that is not running, you cannot modify the objects to be synchronized for the task.

• If you add fields to a data synchronization task, the data of the fields is not synchronized to the destination database.

• If you modify the Synchronization Types parameter when you add an object to a task, the modification takes effect only for the added object.

• You cannot add or modify a data verification task when you modify the objects to be synchronized.

• You cannot modify the Whether to Migrate Accounts parameter when you modify the objects to be synchronized.

• If the destination database is an AnalyticDB for MySQL V2.0 cluster, you must perform the related operations in the DTS console of the previous version.

  Note

  You can move the pointer over the image in the lower-right corner of the DMS console and click the icon to go to the DTS console of the previous version.

• If you select tables as the objects to be synchronized, do not perform DDL operations within 5 minutes before you modify the objects to be synchronized. Otherwise, the DTS task fails.

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.

   Note

   • If you use the DMS console in simple mode, move the pointer over the icon in the upper-left corner and choose All functions > DTS > Data Synchronization. For more information, see Customize the layout and style of the DMS console.

   • You can also go to the Data Synchronization Tasks page of the new DTS console.

2. On the right side of Data Synchronization Tasks, select the region in which your 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. Find the data synchronization task that you want to manage and click Reselect Objects in the Actions column.

4. Modify the objects to be synchronized.

   • Add an object to the data synchronization task

     In the Source Objects section, select the object that you want to add and click the icon to move the object to the Selected Objects section.

     Important

     • You can configure the Synchronization Types parameter to select whether to synchronize the schema and full data of the added object. If you modify the Synchronization Types parameter, the modification takes effect only for the added object.

     • If you use only the object name mapping feature, you must move the object to be synchronized from the Selected Objects section to the Source Objects section and save the modification. After that, add the object to be synchronized to the Selected Objects section. Then, you can use the object name mapping feature. Otherwise, the feature does not take effect.

   • Remove an object from the data synchronization task

     In the Selected Objects section, select the object that you want to remove and click the icon to move the object to the Source Objects section.

5. Click Next: Advanced Settings.

6. Click Next: Precheck and Start Task.

   Note

   • After you modify the objects to be synchronized, the task runs a precheck. You can start the data synchronization task only after the task passes the precheck.

   • If the precheck fails or a warning occurs, fix the issue based on your business requirements and run a precheck again.

7. Wait until the success rate becomes 100%, and click Changed. Return .Success Rate

8. In the Status column, view the status of the task after the objects to be synchronized are modified.

   Note

   If the Auto Refresh feature is disabled, manually click the icon above the Actions column to refresh the status of the synchronization task.Status