Monitoring MySQL replication and rSync backups

[Sheeri Kritzer]

We have done that ourselves; see the attached for a plugin ready to go.  We've
been using it for a few months now and it works swimmingly.



-Sheeri Kritzer
Systems Administrator
University Systems Group
Tufts University
617-627-3925
sheeri.kritzer at tufts.edu


Quoting Jason Martin <jhmartin at toger.us>:

> 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
> 
> -- 
> Are dog biscuits made from collie flour?
> This message is PGP/MIME signed.
> 

-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: check_mysql_rep.pl
URL: <https://www.monitoring-lists.org/archive/users/attachments/20050124/1f9048c7/attachment.pl>