Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

Replication check script

From: Matt Juszczak <matt(at)atopia.net>
Date: Fri Aug 10 2007 - 11:49:01 EDT


Does anyone have a decent replication check script that checks the following:

  1. 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.
  2. 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


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library