If you’ve run into the following error, then there area couple
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.
To give some background first, starting in MySQL 5.6, the server
generates a true UUID in addition to the –server-id supplied by
the user. This is ultimately to help with new replication
From a under-the-hood view, when starting, the MySQL server
automatically obtains a UUID as follows (per the manual):
- Attempt to read and use the UUID written in the file
data_dir/auto.cnf (where data_dir is the server’s data
directory); exit on success.
- Otherwise, generate a new UUID and save it to this file,
creating the file if necessary.