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
可以按照下面的方法解决:
- 在mysql日志目录下删除所有的relay logs,包括hostname-relay-bin.XXX, hostname-relay-bin.index and relay-log.info等等
- 重启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使其都相同