I'd just write a perl script to do it and return the appropriate status code/message to nagios. Shouldn't be hard at all. PhP or any language that can talk to mysql would work, too. You just mentioned the position, you'll have to compare the names of the binlog files as well: position 100 in file bin-00010 is ahead of positions 99999 in file bin-00009.
On Wed, Apr 15, 2009 at 4:12 AM, Gabriel - IP Guys < gabr...@impactteachers.com> wrote: > Good morning guys, (and girls), I hope all is well. I've been given the > task to, and I quote - "Write a Nagios plugin to test the replication > status of two servers by > comparing the position on the master to that on the slave" > > > > To save myself a lot of work, I'd like to know if anything has been done > in this arena already, I would be over the moon, if someone has beaten > me to it, but I am so not in the mood to write one! > > > > Any hints, recommendations, and ideas are wholly welcome! > > > > --- > > Kind Regards, > > Mr Gabriel > > > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
