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 check the manual before using it).
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 check the manual before using it).
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 check the manual before using it).

用户906389531
2023年12月11日
|
浏览 109
这个错误是由于主从复制中主服务器和从服务器的MySQL服务器ID相同导致的。为了使复制正常工作,主服务器和从服务器的MySQL服务器ID必须不同。你可以通过在从服务器上使用--replicate-same-server-id选项来解决这个问题,但这并不总是合理的,请在使用之前参考手册。
我要提问
复制内容
分享给好友
AI编程问答网 免责声明:
以上内容除特别注明外均来源于网友提问,AI编程问答网回答,权益归原著者所有;
