When Can I Stop a Migration Task?
After service cutover is successfully completed, you can stop the migration task to prevent operations in the source database from being synchronized to the destination database to overwrite the data. Before stopping the task, ensure that:
- At least one complete data comparison is performed during off-peak hours.
- Service cutover is completed.
- Interrupt services first. If the workload is not heavy, you may do not need to interrupt the services.
- Run the following statement on the source database (MySQL is used as an example.). If no SQL statement is executed within 1 to 5 minutes, the service is stopped.
show processlist;
The process list queried by the preceding statement includes the connection of the DRS replication instance. If no additional session executes SQL statements, the service has been stopped.
- When the real-time synchronization delay is 0s and remains stable for a period, you can perform a data-level comparison between the source and destination databases. For details about the time required, refer to the comparison results of the previous comparison.
- If there is enough time, compare all objects.
- If there is not enough time, use the data-level comparison to compare the tables that are frequently used and that contain key business data or inconsistent data.
- Determine a proper time to cut the services over to the destination database. Then, services can be used externally again.
- Stopping a task only deletes the replication instance, and the migration task is still in the task list. You can choose whether to delete the task.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot