When you start an incremental data migration task for MySQL, Data Transmission Service (DTS) runs a precheck on the server_id of the source database. This topic describes how to resolve a failed server_id check.
Solution
Log on to the server of your self-managed MySQL database.
Execute the following SQL statement to view the server_id value.
show variables like '%server_id%';The server_id value must be an integer greater than 1. Execute the following SQL statement to change the server_id value.
set global server_id=<id>;Important<id> must be an integer greater than 1 and must be unique among all database server_id values.
If your self-managed database uses a primary-replica replication architecture, ensure that this change does not affect replication.
After you execute the SQL statement, you must also change the server_id value in the configuration file. Otherwise, the change is lost after a restart.
Example:
set global server_id=2;Log on to the DTS console and run the precheck again.