--On Thursday, April 19, 2007 3:47 PM -0700 Donn Cave
We use slurpd, and I have gone to some pains to make our home-grown
service monitor software check the replication files, on the master
hosts, so we have timely notification when replication has stalled.
How do sites that use syncrepl do this?
Buchan Milne made a nice plugin to monitor replication status for syncrepl
as a hobbit plugin. I bastardized his nice script to make it work for me
For example, my new replica is failing right away. I can see it in
the master syslog: a bind, a search for * +, then a search result
with err=3. On the replica side, however - not a peep.
After a little tinkering, I can get "do_syncrep2 result: rid=101 Timed
but that requires changes to the code. This exercise convinced me that
the syncrepl engine isn't supposed to syslog success or failure of its
queries, presumably for some good reason and there must be a better way
to diagnose problems.
The monitoring objective is to verify that the server is either synched,
or is making satisfactory progress in that direction. Is there a good way
to monitor the state of that syncrepl thread?
Yes, it is quite simple. Once merely looks at the contextCSN values at the
root of the database on both the master and slave. If they match, things
are in sync. If they don't, they aren't.
Senior Systems Software Developer
ITS/Shared Application Services
GnuPG Public Key: http://www.stanford.edu/~quanah/pgp.html