同一master,两个slave的server_id相同问题处理

错误日志报错如下:

2017-09-15 18:45:59 1660 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-bin.000958’ at postion 258465890
2017-09-15 18:45:59 1660 [Note] Slave: received end packet from server, apparent master shutdown:
2017-09-15 18:45:59 1660 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-bin.000958’ at postion 258465890
2017-09-15 18:45:59 1660 [Note] Slave: received end packet from server, apparent master shutdown:

错误原因:

同一master,两个slave的server_id相同导致。

解决办法:

修改server_id为不一致。然后重启MySQL即可。

关于mysql多个slave使用同一个server_id产生的问题及原因可以参考这里:

http://hatemysql.com/?p=115

http://www.penglixun.com/tech/database/mysql_multi_slave_same_serverid.html


原文地址:https://www.cnblogs.com/liang545621/p/7543125.html