Before you start a MySQL incremental data migration task, DTS checks the server_id parameter of the source database during the PreCheck. This article describes how to troubleshoot server_id check failures in user-created MySQL source database.
- Log on to the server where the user-created MySQL database resides. Run the following SQL statement to view the value of server_id:
show variables like '%server_id%';
- The value of server_id must be an integer greater than 1. Run the following SQL statement to modify the value of server_id:
set global server_id=[$ID];
- [$ID] is an integer greater than 1 and the value of server_id of other databases is unique.
- Note that if the self-built database is in master-slave mode, ensure that master-slave replication is not affected.
- After the command is run, you need to modify the value of server_id in the configuration file. Otherwise, the modified server_id will become invalid after you restart the instance.
- Login DTS console to perform the PreCheck again.
- Data Transmission Service (DTS)