Kevin Burton
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
thought Jeremy
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]