I wrote this Nagios (http://nagios.org/ - a monitoring tool) specific Perl
plugin a few years ago, but you can easily use it for your needs. The
version I have online does not support mysql 5.0+ but that is easily
remedied..
info;
http://www.byveka.com/files/README.check_replic
script;
http://www.byveka.com/files/check_replic
Cheers,
Atle
On Thu, 15 Nov 2007, bruce wrote:
Hi...
If I have a master/slave setup, I can do a "mysql>show slave status\G" and
get information on the overall status of the slave. Is there a way to break
out this information without having to parse the output? In other words, are
there other cmds that might provide the different pieces of information in a
way that won't require me to parse it?
Basically, I'm trying to figure out the best approach to being able to
automatically look at a mySQL/Slave and determine i it's connected to the
master, and if it's relatively up to date, relative to the master.
Haven't really seen anything on different sites that speak to this issue.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]