Re: MySQL replication status plugin

2009-04-15 Thread Baron Schwartz
I would not compare binlog positions. I would use mk-heartbeat from Maatkit. It tells the truth in a much simpler and more direct way. Instead of checking things that indicate your data is being replicated, just replicate some data and check the data itself. -- MySQL General Mailing List For li

Re: MySQL replication status plugin

2009-04-15 Thread Jim Lyons
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 fil

RE: MySQL replication status plugin

2009-04-15 Thread Andrew Braithwaite
@lists.mysql.com Subject: MySQL replication status plugin 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&quo

MySQL replication status plugin

2009-04-15 Thread Gabriel - IP Guys
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