Source has sent all binlog to replica; waiting for more updates
Replication source changes have been applied at a replica and more changes are being waited for.
Detailed Description​
Source → Replica 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 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.