mysql主从同步报错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.

问题:在mysql主从同步的过程中检查主从同步状态时IO线程报错
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.
解决:从报错信息发现是mysql的server_uuid的原因
1、检查两个mysql实例的uuid发现主从的uuid一模一样
# cat /mysql/data/auto.cnf
[auto]
server-uuid=388c257a-f82e-11e7-aa88-000c2927fe42
2、删除从库的auto.cnf文件并且重启从库实例问题解决:
检查从库复制状态:
show slave status\G;
主从正常

posted on 2018-01-14 14:22  ExzaiTin  阅读(582)  评论(0编辑  收藏  举报

导航