After a newly configured sync task has started, you can modify the sync configuration to add or delete sync objects and modify sync parameters as follows.
When you modify the sync configuration, the existing sync task won't be paused or affected. Except data initialization options, the primary key conflict resolution policy, SQL sync policy, databases, tables, and advanced objects can all be modified.
Adding an object: When the sync task type is set to full + incremental sync, adding a new sync object will result in DTS syncing both the existing and incremental data of the added object to the target database. Conversely, when the sync task type is set to incremental sync only, adding a new sync object will result in DTS syncing only the incremental data of the added object to the target database.
Deleting an object: After the configuration is modified, the incremental data of the deleted object will no longer be synced to the target database, but the data already synced before the modification will be retained.
Modifying the primary key conflict resolution policy: The new policy will be applied only to the data synced after the configuration is modified.
Application Scope
Only the following links support the modification of synchronization configuration operations.
MySQL/MariaDB/Percona/TDSQL-C MySQL > MySQL
MySQL/MariaDB/Percona > MariaDB
MySQL/MariaDB/TDSQL-C MySQL > TDSQL-C MySQL
MySQL/MariaDB/Percona/TDSQL-C MySQL > Kafka
PostgreSQL > PostgreSQL
Notes
1. After the sync configuration modification feature is launched, you can modify only newly initiated tasks.
2. The configuration of a sync task can be modified only if the task is in the Incremental Sync stage and in Running/Task error status and the data gap between the source and target databases is less than 1 GB.
3. When you add or delete objects, be sure to select associated objects together; otherwise, the sync task will fail.
4. When modifying the sync configuration, you can rename only newly added database/table objects. If you modify previously selected objects, the system will report an error during verification, and you need to change them back to the original names.
5. Upon initial modification of the full-speed parameters within the speed limit settings (including full export thread data and RPS, as well as the full import thread count and RPS), subsequent modifications to the sync objects will first redirect users to the speed limit parameter adjustment interface. It is recommended that users increase the full-speed parameters as much as possible (based on a comprehensive assessment of the load conditions of the source and target databases) to prevent prolonged duration of full sync for added objects.
Directions
1. Log in to the DTS console, select Data Sync on the left sidebar, select the target sync task, and click Modify Sync Configuration in the Operation column.
The configuration of a task can be modified only if the task is in the Incremental Sync stage and in Running/Task error status and the data gap between the source and target databases is less than 1 GB. It cannot be modified in other statuses such as Task failed.
2. (Optional) Verify if there is a need to adjust the speed parameters, and upon confirmation, click OK.
Note：
Upon initial modification of the full-speed parameters within the speed limit settings (including full export thread data and RPS, as well as the full import thread count and RPS), subsequent modifications to the sync objects will first redirect users to the speed limit parameter adjustment interface. It is recommended that users increase the full-speed parameters as much as possible (based on a comprehensive assessment of the load conditions of the source and target databases) to prevent prolonged duration of full sync for newly added objects.
3. On the sync task configuration page, in Set sync options and objects, modify relevant parameters such as objects and the primary key conflict resolution policy, and click Save and Go Next. Except data initialization options, all options can be modified.
4. Verify the task again. After the verification is passed, click Start Task.
5. Return to the task list, and you can see that the task status is Running (dynamically modifying configuration), meaning that DTS is processing the data after modification.
Notes:
After the sync configuration is modified, when the task is in Running (dynamically modifying configuration) status, do not perform DDL operations on the source database; otherwise, the task may fail.
When you add a sync object, DTS will first sync the existing data of the object to the target database. If the volume of the existing data is high, the task will remain in Running (dynamically modifying configuration) status for a long time.
When the task status becomes Running, the configuration has been modified, and you can modify the configuration again if needed.
