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

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

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

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

ubuntu@ip-172-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!!!

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest
Share on print
Share on email