mysql 从库宕机导致主从同步失败处理
Last_Errno: 1594
Last_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.
Relay_Master_Log_File: mysql-bin.001067
Exec_Master_Log_Pos: 391547354
stop slave;
change master to master_log_file='mysql-bin.001067', master_log_pos=391547354;
start slave;