tencent cloud

Feedback

Cutover Description

Last updated: 2022-08-14 16:27:58

    Notes

    • To better distinguish between sessions and improve data security, we recommend you create a separate database account for data migration.
    • As cutover requires pausing data writes into the source database, we recommend you cut over the business during off-peak hours.

    Directions

    1. Log in to the DTS console and proceed based on whether incremental migration is involved:
      • Incremental migration is involved: go to step 2.
      • Incremental migration is not involved: go to step 6.
    2. Wait until the Migration Step of the data migration task becomes Syncing Incremental Data, the source-target database data gap is 0 MB, and the source-target database time lag is 0s.
    3. Pause the business in the source database and stop writing new data.
    4. Choose the appropriate code below based on your source database type to view whether there is new session information. If the result shows that no new sessions are being executed except the connection of the DTS migration instance in 1–5 minutes, the business can be considered completely stopped.
    • MySQL

      show processlist  
      
    • SQL Server

      select * from sys.dm_exec_connections;
      
    • PostgreSQL

      select * from pg_stat_activity;
      
    • MongoDB

      use admin
      db.runCommand({currentOp: 1, $all:[{"active" : true}]})
      
    1. Stop the incremental migration task.
      View the migration task again, wait for at least 1 minute after the source-target database data gap is 0 MB and the source-target database time lag is 0s, and click Complete to stop the incremental migration task.
    2. After confirming that the data in the source and target databases is consistent, determine the cutover time, route the business system to the target database, and resume the business.
    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