Monitoring MySQL replication and rSync backups

Jason Martin jhmartin at toger.us
Fri Jan 21 17:22:46 CET 2005


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 --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 211 bytes
Desc: not available
URL: <https://www.monitoring-lists.org/archive/users/attachments/20050121/f758a617/attachment.sig>


More information about the Users mailing list