Wednesday, 9 November 2016

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

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 Code:


  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.

Solved:

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

No comments:

Post a Comment