Friday, May 2, 2014

Mysql Replication: 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.

if you get this 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.

Go to the installlation/source folder of mysql and change the guid in the file ./data/auto.cnf. Generate another guid with http://www.famkruithof.net/uuid/uuidgen, copy the generated guid and replace the existing guid:

from:

[auto]
server-uuid=e80f7b10-d242-11e3-9c1a-0800200c9a66

to:

[auto]
server-uuid=839567f0-d245-11e3-9c1a-0800200c9a66

Resource:
http://planet.mysql.com/entry/?id=103096







No comments: