wrote recently about why
SHOW SLAVE STATUS is really not a
good way to monitor how far behind your slave servers are,
and how slave network timeouts can mess up the slave
lag. I'd like to chime in and say this is exactly why I
Cole's MySQL Heartbeat script was such a natural fit for
the MySQL Toolkit. It measures slave lag in a "show me the money"
way: it looks for the effects of up-to-date replication,
rather than asking the slave how far behind it thinks it is.
The slave doesn't even need to be running. In …[Read more]