My recent poll What alert monitoring do you use? showed 25% of the 58 respondents to bravely state they had no MySQL monitoring. I see 1 in 3, ~33% in my consulting so this is consistent.
There is no excuse to not have some MySQL Monitoring on your production system. At the worse case, you should be logging important MySQL information for later analysis. I use my own Logging and Analyzing scripts on every client for an immediate assessment regardless of what’s available. I combine that with my modified statpack to give me immediate text based analysis, broken down by hour chunks for quick reference. These help me in troubleshooting, but they are not a complete solution.
The most popular options I see and are also reflected in the results are:
- Cacti with MySQL Cacti Templates – Open Source
- Nagios used in conjunction with Cacti for alert monitoring – Open Source
- MONyog – Commercial with Free trial
There is a good list, including some products I did not know. My goal is to get this information included in the Monitoring-MySQL information site.
I have some additional information on Cacti and MONyog, and I’ll be sharing this information in upcoming posts.
Tags: cacti, MONyog, mysql monitoring, nagios
This entry was posted
on Thursday, October 15th, 2009 at 3:12 pm and is filed under Databases, Linux, MySQL, Professional, Uncategorized, Web Sites.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
