tencent cloud

Feedback

Cutover Description

Last updated: 2021-12-27 10:55:09

    Notes

    • To better distinguish between sessions and improve data security, we recommend you create a separate database account for data migration.
    • To avoid data inconsistency between the source and target databases due to business cutover failures, switch the business in the source database to a backup database before cutover.
    • 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}]})
        
    5. 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.
    6. 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