tencent cloud

Feedback

Pausing Task

Last updated: 2024-07-08 20:31:47

    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 migration links among MySQL, TDSQL-C for MySQL, MariaDB, and Percona.

    Note

    Only migration tasks in Running or Prepared 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 migration, 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 and binlog of the source database during the task pause, billable links will still be billed when the migration task is paused.

    Directions

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

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

    Technical Support

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

    7x24 Phone Support