I have master/slave replication with 5 slaves and 1 master. The master is mysql 5.1.37 and the slaves are 5.5.8.
Two days ago one of the slave stopped working. In "show slave status" I see that both IO thread and SQL thread are running. The IO thread is generating relay-log files but the SQL thread is not applying the changes... The "seconds behind master" is showing "0" even though I know it's far behind (Checking the binlog using mysqlbinlog).
All the other slaves are working properly.
Don't know what to look for (no errors in mysql log file and no errors in system logs...)
any advice? See below slave status output
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: master-db
Master_User: replication
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.020839
Read_Master_Log_Pos: 56173153
Relay_Log_File: research-relay-bin.000002
Relay_Log_Pos: 252
Relay_Master_Log_File: mysql-bin.020828
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: db1,db2,db3,db4
Replicate_Ignore_DB: db5,db6
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: 975734937
Relay_Log_Space: 10714389571
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: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 300