MySQL slaves catch up with master

Even if running “show slave status” will show there is no delay but it could still receiving data from the master. Check it by running “show processlist” on the master. If the status is “Writing to net”, it’s still sending data to that slave. If it’s “Has sent all binlog to slave; waiting for binlog to be updated”, then you can be sure it’s done and all rows match. It takes a while for about 11 slaves to sync with our chained master.


Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *