How to fix master and slave have equal MySQL server UUIDs MySQL Error

December 16, 2019 in Database



How to fix master and slave have equal MySQL server UUIDs MySQL Error
I tried to enable master slave replication this morning and I met this 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.
Server UUIDs is automatically generated but it was copied when I cloned mysql instance using AWS AMI
[email protected]:/var/lib/mysql$ cat /var/lib/mysql/auto.cnf
[auto]
server-uuid=fea4e713-9552-11e6-a093-06a1a5e379d3
It can be simply fixed by removing that auto generated auto.conf file and restart MySQL server. Enjoy your MySQL Master-Slave replication!!!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.