I have one master and 2 slaves,one is replicating but another slave which is read-only not replicating.
From Master :
show master status;
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | |
| mysql-bin.002490 | 13000479 | | |
Slave : Master has sent all binlog to slave; waiting for more updates
Slave_IO_State: Waiting for master to send event Master_Host: .... Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.002490 Read_Master_Log_Pos: 13106512 Relay_Log_File: mysql-relay-bin.000018 Relay_Log_Pos: 13106725 Relay_Master_Log_File: mysql-bin.002490 Slave_IO_Running: Yes Slave_SQL_Running: Yes Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 13106512 Relay_Log_Space: 13107019 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Seconds_Behind_Master: 0 Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
slave processlist show below for system user
i. Waiting for master to send event
ii.Slave has read all relay log; waiting for more updates
Still not replicating.what i have to check ?
Thanks in advance.