2020-11-27
mysql主从复制,报错errno:1594
论坛大佬们好,想请教一根问题,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来补齐呢?
我来答
添加附件
收藏
分享
问题补充
2条回答
默认
最新
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏

评论
