Mysql replication is enabled but stuck at "waiting for binlog to be updated"
MySQL Replication is running just fine. How do I know ?

Slave_IO_Running: Yes
Slave_SQL_Running: Yes


This indicates that the two replication threads are alive.

To verify this, run the following on the Slave:

SELECT COUNT(1) ReplicationThreadCount FROM information_schema.processlist
WHERE user = 'system user';


If ReplicationThreadCount > 1, then replication is running just fine.

You can also run SHOW PROCESSLIST; and look for two connections whose user is system user

The two states you mentioned for the Master and Slave are normal for a running replication status

As you add data to the Master, you can know that data is coming to the Slave by looking at


Read_Master_Log_Pos
Exec_Master_Log_Pos
Relay_Log_Space


in the output of SHOW SLAVE STATUS\G. These numbers will be changing, which indicate its working.