首页fatal error: the slave i/o thread stops because master and slave have equal mysql server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please c

fatal error: the slave i/o thread stops because master and slave have equal mysql server ids; these ids must be different for replication to work (or the --replicate-same-server-id option must be used on slave but this does not always make sense; please c

时间: 2023-05-04 22:01:08 浏览: 1158

master and slave have equal MySQL server UUIDs 解决方法

使用rsync配置了大量mysql，省去了大量编译和配置的时间，随逐个修改master和slave服务器的my.cnf，后，发现数据不能同步，在slave服务器show slave status: 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> show variables like ‘server_id’;+—————

致命错误：从IO线程停止，因为主从数据库服务器具有相同的MySQL服务器ID；这些ID必须不同才能进行复制（或在从节点上使用--replicate-same-server-id选项，但这并不总是有意义）；请检查并修复主从数据库服务器的MySQL服务器ID配置。

阅读全文