[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: Syncrepl out-of-sync detection.

On Tuesday 22 August 2006 04:08, Jose Ildefonso Camargo Tolosa wrote:
> Hi!
> I know that this question may have been asked before on this forum.
> But I just can't find the threads where it was discussed.
> Is there a way of telling wich slaves are not on sync on a syncrepl
> deployment?  I mean, a "fast" way of telling whether "this" replica is
> not in sync.

I use the attached perl script to monitor performance and replication status 
with Hobbit (hobbitmon.sf.net), which then also keeps rrd files for the 
performance metrics which it graphs on the page for this test.

You can use the perl script without Hobbit, I do this when I have a new slave 
and am waiting for it to sync.

It assumes it will have anonymous access to the monitor backend on the 
consumer you are checking, and the base entry of each database (on the 
consumer and it's provider)


Buchan Milne
ISP Systems Specialist

Attachment: pgpaQINRZ7yAZ.pgp
Description: PGP signature