I have a simple MySQL-MMM setup with a dedicated monitoring host as described in their installation guide. I also have a separate monitoring system that is able to check status URLs so I'd like to set up some simple monitors to check for the status based on the output of this command:
[root@host ~]# mmm_control show db1(10.10.1.15) master/ONLINE. Roles: writer(10.10.1.20) db2(10.10.1.16) master/ONLINE. Roles: reader(10.10.1.30) db3(10.10.1.17) slave/ONLINE. Roles: reader(10.10.1.31)
Unfortunately because this is a command in /usr/sbin and seems to need to run in root's environment I can't simply execute it from a CGI.
Can anyone suggest a simple method for remotely monitoring the status of the MMM?