问题:最近公司服务器Mysql主从同步
通过执行show slave status\G; 查看返回的
Slave_IO_Running: Yes
Slave_SQL_Running: Yes,
状态一切正常
可是数据无法正常同步,
经一番排查,是主从同步断开连接,通过如下步骤操作就可以恢复
1、确定主从同步问题,用txt打开文件C:\ProgramData\MySQL\MySQL Server 5.5\data\WIN-L2N8ANRGSLS.err查看到如下报错
200410 7:52:57 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)
200410 7:52:57 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000051' at position 27394280
2、到主服务器执行
show master status;
3、在从服务执行如下代码,即可修复主从同步问题
stop slave;
change master to master_log_file='mysql-bin.000051',master_log_pos=46234080;
start slave;
show slave status\G;