Rsync is used to configure a large number of mysql instances, saving a lot of time for compilation and configuration. After modifying my. cnf of the master and slave servers one by one, it is found that the data cannot be synchronized,
On the slave server, show slave status:
Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work.
First check:
Mysql> show variables like 'server _ id ';
+ ----- + --- +
| Variable_name | Value |
+ ----- + --- +
| Server_id | 3 |
+ ----- + --- +
The master and slave are not the same. This problem is ruled out.
Continue to troubleshoot and find out the reason: copy the entire data directory and copy the auto. cnf file, which records the uuid of the database. The uuid of each database should be different.
[Auto]
Server-uuid = 6dcee5be-8cdb-11e2-9408-90e2ba2e2ea6
Solution: Follow the hexadecimal format to change it and restart mysql.