MySQL Replication Error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs

The slave I/O thread stops because master and slave have equal MySQL server UUIDs

This is a common issue that happens while configuring replication in between cloned MySQL servers.

Cloned servers have the same UUIDs. But the servers should have unique UUIDs for replication to work.

We can follow the below steps to resolve this issue.

Step1: Login to the server via ssh as root.

Step2: Switch to the MySQL data folder.

#cd /var/lib/mysql

Note that this path may vary according to the OS distributions.

Step3: Remove the file "auto.cnf".

#rm auto.cnf 

Step4: Restart MySQL service

#systemctl restart mysqld

That's all….

Leave a Reply

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