Monday, 2 December 2019

MYSQL: Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs

In mysql replication using VM clone,getting below error in the DR status

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.

Solution:
in DR: Move /var/lib/mysql/auto.cnf
mv /var/lib/mysql/auto.cnf /var/lib/mysql/auto.cnf_old
and restart mysql

/etc/init.d/mysqld restart

No comments: