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

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

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

Join The Ride

Subscribe to our fortnightly newsletter with stories from our latest adventures and the best travel tips

Table of Contents