Does anyone have a decent replication check script that checks the following:
- Does multiple polls to verify exec_master_log_pos and
relay_master_log_pos are changing, so that, even if replication is behind,
we still know that it is actually working (IE: I've seen seconds behind
master as 0 because the slave lost connection to the master but didn't
actually know it. Checking exec_master_log_pos verifies that indeed, the
replication aspect of things is working, even if its behind.
- Can tell the difference between replication actually being behind
(lagging behind) and the times of replication being behind because of a
slow running query or a locked query on the slave (As in, the SQL thread
and I/O threads are working fine, but they are just waiting for a query on
the slave to finish, so seconds behind master is showing a 10 or 15
second value, but as soon as the query is done, replication catches up: in
my opinion, this is only something to warn about, not take replication
down for).
Thanks,
Matt
--
MySQL Replication Mailing List
For list archives:
http://lists.mysql.com/replication
To unsubscribe:
http://lists.mysql.com/replication?unsub=lists@pantek.com
Received on Fri Aug 10 12:06:43 2007
This archive was generated by hypermail 2.1.8
: Sun Oct 07 2007 - 10:14:20 EDT
|