Monitoring MySQL replication and rSync backups

Dan Stromberg strombrg at dcs.nac.uci.edu
Fri Jan 21 18:48:02 CET 2005


I wrote this script for basically this purpose:

http://dcs.nac.uci.edu/~strombrg/verify.html

It was written for verifying the correct data transfer from a suspect
source, to a suspect source, using md5 and a statistical sample of the
files transfered, with a user-specified sampling rate.  :)

HTH.

On Fri, 2005-01-21 at 08:22 -0800, Jason Martin wrote:
> On Fri, Jan 21, 2005 at 12:00:48PM +0000, Alastair Battrick wrote:
> > Any idea how I can check if 2 servers are correctly MySQL replicated and 
> > correctly rSync'd ?
> One could write a plugin that does a SHOW MASTER STATUS / SHOW
> SLAVE STATUS against the appropriate servers and check that the
> log positions are not more than X positions apart. It looks like
> this book (http://6URL.com/AAZ) has some sample code, although
> it isn't in the form of a Nagios plugin.
> 
> rSync backups could be monitored by having the job log and
> monitoring the logfile or making the backup job a passive
> check.
> 
> -Jason Martin
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL: <https://www.monitoring-lists.org/archive/users/attachments/20050121/a7041eb1/attachment.sig>


More information about the Users mailing list