Mysql 复制停止且没有错误

Question

Mysql 5.1 复制停止，没有错误消息

"SHOW SLAVE STATUS\G"
> *************************** 1. row ***************************
>                Slave_IO_State: Waiting for master to send event
>                   Master_Host: xxx
>                   Master_User: repl
>                   Master_Port: 3306
>                 Connect_Retry: 60
>               Master_Log_File: mysql-bin.000366
>           Read_Master_Log_Pos: 6491726
>                Relay_Log_File: mysql-relay-bin.000003
>                 Relay_Log_Pos: 75183691
>         Relay_Master_Log_File: mysql-bin.000351
>              Slave_IO_Running: Yes
>             Slave_SQL_Running: Yes
>               Replicate_Do_DB: xxx
>           Replicate_Ignore_DB: 
>            Replicate_Do_Table: 
>        Replicate_Ignore_Table: 
>       Replicate_Wild_Do_Table:    
>   Replicate_Wild_Ignore_Table: 
>                    Last_Errno: 0
>                    Last_Error: 
>                  Skip_Counter: 0
>           Exec_Master_Log_Pos: 75698643
>               Relay_Log_Space: 1624786550
>               Until_Condition: None
>                Until_Log_File: 
>                 Until_Log_Pos: 0
>            Master_SSL_Allowed: No
>            Master_SSL_CA_File: 
>            Master_SSL_CA_Path: 
>               Master_SSL_Cert: 
>             Master_SSL_Cipher: 
>                Master_SSL_Key: 
>         Seconds_Behind_Master: 6222 
> Master_SSL_Verify_Server_Cert: No
>                 Last_IO_Errno: 0
>                 Last_IO_Error: 
>                Last_SQL_Errno: 0
>                Last_SQL_Error:

Master 上的最后一个 binlog 是 mysql-bin.000365

我应该做什么和阅读来解决这个问题？

Answer 1

您需要重新配置 MySQL Slave，因为您的从服务器显示 Master_Log_File: mysql-bin.000366，但您说您的 Master 位于 mysql-bin.000365。这就是为什么你的从站无法与主站同步的原因。要重新配置从站，请按照此处进行设置