tencent cloud

All product documents
Data Transfer Service
DocumentationData Transfer ServiceData SyncTask ManagementPausing Task
Pausing Task
Download PDF
Last updated: 2024-07-08 19:09:49
Pausing Task
Last updated: 2024-07-08 19:09:49
Download PDF

Overview

After a sync task is started, if there are too many connections to the source database or the business needs to be adjusted, you can pause the task and resume it after the source database can handle the load or the business adjustment is completed.

Application Scope

Data sync links among MySQL, TDSQL-C for MySQL, MariaDB, and Percona.

Note

Only sync tasks in Running status can be paused.
After a task is paused, DTS will continue to pull the source database data but will not write data to the target database. After the task is resumed, DTS will continue the task.
In the full export stage, after a task is resumed, the checkpoint restart is not supported, and DTS needs to export all the source database data again.
In the full import and incremental sync stages, after a task is resumed, DTS will continue with the data transfer based on the offset of the binlog synced before the task is paused.
During sync, binlog records are retained for up to seven days. If the pause lasts longer than seven days, the task will fail and cannot be restarted. We recommend that you keep the pause period below three days.
Because DTS continues to pull the data of the source database during the task pause, billable links will still be billed when the sync task is paused.

Directions

1. Log in to the DTS console, select Data Sync on the left sidebar, select the target sync task, and click Pause in the Operation column.
2. In the pop-up window, confirm that everything is correct and click OK.

Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 available.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon