mysql 数据库主从同步问题解决——筑梦之路

mysql主从复制问题解决：

报错信息如下：
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.

原因分析：

中继日志中断或者网络故障

解决方法：

查看show slave status\G;
找到如下：
 Master_Log_File: mysql-bin.000049
 Read_Master_Log_Pos: 67691711

 停掉slave，以slave已经读取的binlog文件，和已经执行的position为起点，重新设置同步。会产生新的中继日志，问题解决。
 
 stop slave;
 
 change master to master_log_file='mysql-bin.000049' , master_log_pos=67691711;
 
 
 验证：show slave status\G;