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!!!