MySQL日常排错

1、MySQL从库 Failed to open the relay log

在配置MySQL主从复制的过程中，遇到了一个问题，提示：Could not initialize master info structure; more error messages can be found in the MySQL error log。

打开log日志发现是因为如下的原因：

111121 15:15:22 [ERROR] Failed to open the relay log ‘./dong-relay-bin.000002’ (relay_log_pos 1067)
111121 15:15:22 [ERROR] Could not find target log during relay log initialization

可以按照下面的方法解决：

1. 在mysql日志目录下删除所有的relay logs，包括hostname-relay-bin.XXX, hostname-relay-bin.index and relay-log.info等等
2. 重启mysql服务

 2、MySQL从库报错log

171103  9:55:49 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000268' at postion 141228974
171103  9:55:49 [Note] Slave: received end packet from server, apparent master shutdown: 
171103  9:55:49 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000268' at postion 141228974
171103  9:55:49 [Note] Slave: received end packet from server, apparent master shutdown: 
171103  9:55:49 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000268' at postion 141228974

原因：my.cnf里server-id与master或其他slave里的server-id冲突（注意MySQL可能读取了多个配置文件）

解决方案：

修改my.cnf里server-id使其都相同

转载于:https://www.cnblogs.com/jadexia/p/7717192.html