论坛大佬们好,想请教一根问题,mysql主从遇到了一个报错 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
网上的办法是重建binlog_file 和master_log_pos, 如果这样操作的话,备库备份的数据和主库的数据还一致么,是不是会缺少pos值之前的数据呢?
还是mysql会自动将前面缺少的内容通过binlog来补齐呢?
讨论了MySQL主从复制中遇到的错误errno:1594,即relay log读取失败的问题。分析了可能的原因包括binlog损坏、relay log损坏、网络问题等,并探讨了解决方案。

被折叠的 条评论
为什么被折叠?



