Sunday, October 27, 2013

Resolved : The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work.

Starting mysql 5.6 the server generates a true UUID in addition to the –server-id supplied by the user.
 So remove auto.cnf file under data directory then restart mysql server after that new auto.cnf file will be created .

Error:


  Last_IO_Error: 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.

 Workaroud:

*Remove auto.cnf file under data dir
*Restart mysql server



No comments: