Mysql 主从出现故障

今天由于 slave 机异常掉电导致主从同步出现异常

在 slave mysql 上查看 slave 状态:
show slave status\G

发现 IO 线程正常,但是 SQL 线程 NO,错误如下:

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.

查看 mysql 错误日志:

160817 18:01:14 [ERROR] Error in Log_event::read_log_event(): 'read error', data_len: 1011, event_type: 23
160817 18:01:14 [ERROR] Error reading relay log event: slave SQL thread aborted because of I/O error
160817 18:01:14 [ERROR] Slave SQL: 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. Error_code: 1594
160817 18:01:14 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000022' position 1068142925

We stopped at log ‘mysql-bin.000022’ position 1068142925

重新定位 master binlog

stop slave;
change master to master_host='172.16.18.114',master_user='root',master_password='cpyf', master_log_file='mysql-bin.000022',master_log_pos=1068142925;
start slave;

show slave status\G

SQL Thread 正常了。
应该是异常掉电导致 relay-log 错误导致的。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值