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.
MySQL slaves catch up with master
by
Tags:
Leave a Reply