有台MySQL从库报错如下:
080211 22:18:44 Slave I/O thread: Failed reading log event, reconnecting to retry, log 'Content3325.013' position 741096772 080211 22:18:44 Slave: connected to master '****@****:3306',replication resumed in log 'Content3325.013' at position 741096772 080211 22:18:44 Slave: received 0 length packet from server, apparent master shutdown:
记录处理过程
断定是server-id相同了
先在master服务器看一下server-id
show slave hosts;
找到设置不正确的服务器并更正为正确的server-id
slave starat;
好了，搞定了。
Leave a comment