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]31-26-201:/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

Your email address will not be published. Required fields are marked *