Slave: received end packet from server, apparent master shutdown:

数据库的一台从产生大量的如下错误: 140121 13:56:07 [Note] Slave: received end packet from server, apparent master shutdown:
140121 13:56:07 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-bin.003062′ at postion 220648071
140121 13:56:09 [Note] Slave: received end packet from server, apparent master shutdown:
140121 13:56:09 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-bin.003062′ at postion 220718334
140121 13:56:10 [Note] Slave: received end packet from server, apparent master shutdown:
140121 13:56:10 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘mysql-bin.003062′ at postion 221074239
140121 13:56:12 [Note] Slave: received end packet from server, apparent master shutdown:
原来slave上的my.cnf 配置文件是一台台拷贝的,忘记修改server-id值,导致server-id值相同,切记,切记,server-id值一定保持唯一。
参考:http://nettedfish.sinaapp.com/blog/2013/07/24/how-to-generate-unique-server_id/

这种情况下复制会左右摇摆。当两个从库的server-id相同时,如果从库1已经连接上主库,此时从库2也需要连接到主库,发现之前有server-id相同的连接,就会先注销该连接,然后重新注册。 两台从库不停的注册,不停的注销,会产生很多relay log文件,查看从库状态会看到relay log文件名不停改变,从库的复制状态一会是yes一会是正在连接中

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值