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
             Skip_Counter: 0
      Exec_Master_Log_Pos: 13106512
          Relay_Log_Space: 13107019
          Until_Condition: None
            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 else can I check ?

Thanks in advance.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.