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 status:
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 ?
Any suggestions.
Thanks in advance.