如果是克隆的机器 两个mysql的uuid很可能相同。

问题出现:mysql数据库主从备份完毕后查看信息发现

 show slave status \G;
如下报错:

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.

解决方案:找到对应的 uuid 发现该文件在/var/lib/mysql/auto.cnf下

 

master and slave have equal MySQL server UUIDs问题解决_mysql

master and slave have equal MySQL server UUIDs问题解决_mysql主从备份_02

将里面uuid的值随便改一个即可

重启服务:service mysqld restart;

再次查看 发现主从备份成功:

master and slave have equal MySQL server UUIDs问题解决_mysql主从备份_03