Help Center>
Data Replication Service>
FAQs>
Real-Time Migration>
How Do I Ensure that All Services on the Database Are Stopped?
Updated on 2023-07-03 GMT+08:00
How Do I Ensure that All Services on the Database Are Stopped?
To ensure that all services on the database are stopped, perform the following steps:
- Run the following statement on the source database to check whether active connections exist:
show processlist;
Figure 1 Checking active connections
- Optional: If there are active connections, locate the service processes based on the values in the Host column in the command output and stop the service processes.
- Run the following statement in the source database to check the binlog position. Then, record the two values in the file and position columns as ckpt1:
show master status;
Figure 2 Viewing the binlog position
- Wait for more than 30s. Run the following statement in the source database to check the binlog position again. Then, record the two values in the file and position columns as ckpt2. If ckpt1 and ckpt2 are equal, no data is written to the source database.
show master status;
Parent topic: Real-Time Migration
Real-Time Migration FAQs
- When Can I Stop a Migration Task?
- How Do I Maintain the Original Service User Permission System After Definer Is Forcibly Converted During MySQL Migration?
- What Can I Do If the Invoking Permission Problem Occurs After the MySQL Stored Procedure Is Migrated to the Cloud?
- How Do I Ensure that All Services on the Database Are Stopped?
- What Can I Do When Message "can not get agency token" Is Displayed in the Migration Log
- What Do I Do If the Maximum Index Length Has Been Reached During Migration from Oracle to MySQL?
- Why Is the Collation of Heterogeneous or Oracle Databases Converted to utf8mb4_bin After Those Databases Are Migrated to MySQL?
- What Can I Do If MyISAM Tables Are Not Supported by RDS for MySQL?
- What Are the Precautions for Migrating Data from an Earlier Version MySQL to MySQL 8.0?
- What Can I Do When OOM Occurs During the Migration of MongoDB Databases?
- How Do I Disable the Balancer?
- How Do I Export and Import Events and Triggers in Batches?
- How Can I Migrate Databases or Tables Whose Names Contain Uppercase Letters?
- How Do I Delete Orphaned Documents in MongoDB Sharded Clusters?
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
more