Forum Discussion

andrew_waldvoge's avatar
andrew_waldvoge
Icon for Nimbostratus rankNimbostratus
Jan 23, 2007

mysql monitoring

I'm looking for a way to configure monitoring for a mysql database.   Currently we have the following rule in place which monitors the database indirectly through the URL, but whenever apache or to...
management
monitoring
JRahm's avatar
JRahm
Icon for Admin rankAdmin
Jul 20, 2007
If you're looking for a binary state (ie, up or down), then your best bet would be an external monitor. Write a shell or perl script to log into the database, do whatever checking you need to do, and if all is good, return a 1, otherwise, return a 0. In fact, there are plenty of monitor script out there that you could customize to meet your needs, the url to one is below:

 

 

http://blog.arabx.com.au/?p=695 Click here

 

 

Make sure to note your script execution time so that it doesn't exceed your polling interval.