/var/log/mysql.log错误日志:
[ERROR] Slave I/O: error connecting to master 'syc@1.1.1.1:3306' - retry-time: 300 retries: 999, Error_code: 2013
show slave status:
Master_Log_File: mysql-bin.000010
Read_Master_Log_Pos: 739386385
Relay_Log_File: mysqld-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: mysql-bin.000010
Slave_IO_Running: No
Slave_SQL_Running: Yes
解决方法:
stop slave;
CHANGE MASTER TO Relay_Log_Pos=588;
start slave;
show slave status \G
跳过出问题的点,修复此问题.
网友评论