mysql同步中的问题
一台master带三台slave
今天三台slaves上执行show slave status命令式,同时出现错误:
Last_SQL_Errno: 1594
Last_SQL_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave.
以前遇上的情况是Read_Master_Log_Pos不再增长,只需要从这个同步点重新恢复一下即可。
但现在的问题是Read_Master_Log_Pos还一直在增长,Relay_Log_Pos倒是不再增长了。这种情况下,我该如何查找同步点呢?Relay_Log中的同步点的计数跟Master_Log都不一致呀。。。