Master has sent all binlog to slave; waiting for binlog to be updated
Replication source changes have been applied at a replica and more changes are being waited for.
Detailed Description​
Master → Slave replication is in place. Replication transactions are written to a binary log (binlog). All remaining transactions from the binary logs have been read and sent to the slave or replica. The replication thread is now idle, waiting for new events in the master to send to the replica.
At version 8.0.26 replication terms changed from ‘master’ to ‘source’, ‘slave’ to ‘replica’ and from ‘multithreaded server’ (mts) to ‘multithreaded applier’ (mta).
How to reduce this wait​
This is a normal idle wait state for databases with replication set up.
Additional Links​
- MySQL Documentation - General thread states - Executing
- MySQL docs - Replication Administration Status
- INFOHUBBLOG - MySQL Master Slave Replication | Complete Guide
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.