该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
有一台从库的同步停了,怎么都起不来,报错是:
Last_IO_Error: error connecting to master 'repl@172.16.11.58:3306' - retry-time: 60 retries: 86400
show salve status 如下:
Slave_IO_State: Connecting to master
Master_Host: 172.16.51.58
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.009312
Read_Master_Log_Pos: 131853911
Relay_Log_File: mysql-relay-bin.003192
Relay_Log_Pos: 131854056
Relay_Master_Log_File: mysql-bin.009312
Slave_IO_Running: No
Slave_SQL_Running: Yes
然后主库上的show master status如下:
File: mysql-bin.000059
Position: 120
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set:
我发现主和从的File和Position是不一致的,是这个原因造成从库的同步起不来么?
如何修复??谢谢!!
非常着急,十分感谢!!!!!