下午搭建了mysql一主多从,晚上查看slave日志的时候,发现slave服务器上错误日志不停的输出
130530 20:50:37 [Note] Slave: received end packet from server, apparent master shutdown:
130530 20:50:37 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000009' at position 752065283
130530 20:50:37 [Note] Slave: received end packet from server, apparent master shutdown:
130530 20:50:37 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000009' at position 752065283
130530 20:50:37 [Note] Slave: received end packet from server, apparent master shutdown:
130530 20:50:37 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000009' at position 752065283
130530 20:50:37 [Note] Slave: received end packet from server, apparent master shutdown:
130530 20:50:37 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000009' at position 752065283
130530 20:50:37 [Note] Slave: received end packet from server, apparent master shutdown:
130530 20:50:37 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000009' at position 752065283
130530 20:50:37 [Note] Slave: received end packet from server, apparent master shutdown:
130530 20:50:37 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000009' at position 752065283
130530 20:50:38 [Note] Slave: received end packet from server, apparent master shutdown:
130530 20:50:38 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000009' at position 752065283
130530 20:50:38 [Note] Slave: received end packet from server, apparent master shutdown:
130530 20:50:38 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000009' at position 752065283
130530 20:50:38 [Note] Slave: received end packet from server, apparent master shutdown:
130530 20:50:38 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000009' at position 752065283
130530 20:50:38 [Note] Slave: received end packet from server, apparent master shutdown:
130530 20:50:38 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000009' at position 752065283
原来slave上的my.cnf 配置文件是一台台拷贝的,忘记修改server-id值,导致server-id值相同,切记,切记,server-id值一定保持唯一。
修改server-id,重启mysql server,ok。