EmergencyEMERGENCY? Get 24/7 Help Now!

Announcing MySQL Monitoring Plugins from Percona

 | February 17, 2012 |  Posted In: Events and Announcements, Insight for DBAs, MySQL, Percona Software

PREVIOUS POST
NEXT POST

We’ve released a new set of monitoring plugins for MySQL servers and related software. With these plugins, you can set up world-class graphing and monitoring for your MySQL servers, using your own on-premises Cacti and Nagios software. The Cacti plugins are derived from an existing set of templates we’ve been using for several years, but the Nagios check plugins are brand new. They are informed by the research we did into the causes and preventions of MySQL downtime.

Like all Percona software, the plugins are open-source and free, licensed under the GNU GPL. The source code and issue tracker are hosted at Launchpad. The 0.9.0 release is ready to download now, and the reference manual is also online. In the next release we will integrate this into our package management, so you can install through YUM and APT repositories.

The new monitoring plugins add first-rate support for MySQL to popular enterprise opensource monitoring systems, and that’s why we’ve added them to the list of software included in our support contracts. If you’re an existing customer of Percona’s MySQL Support services, your contract automatically covers these new plugins, too; you don’t need a new contract for that. Under the support contract, you’ll get help installing, configuring, troubleshooting, and administering your monitoring plugins, as well as being entitled to bug fixes. And as always, we’re also available to extend the plugins to support your environment or broaden the range of systems and software that they can monitor.

Please use the Launchpad bug tracker to report issues. Happy monitoring!

PREVIOUS POST
NEXT POST
Baron Schwartz

Baron is the lead author of High Performance MySQL. He is a former Percona employee.

21 Comments

  • How different are these from the orginal Cacti MySQL graphs you created? I’ve imported the earlier Cacti graphs into Zabbix so I am wondering if these would be considered a replacement or an upgrade?

  • Most of the graphs are similar. Some major backwards-incompatible changes are introduced, some of them to work around bugs in Cacti itself. I took the opportunity to change specific graphs in ways I was hesitant to do before because it would be backwards incompatible, too.

    Of course, the Nagios plugins are all-new.

  • Great to see it as a whole package for both Cacti and Nagios. We use both of them and currently get way more information out of Cacti than Nagios and with this we can even that out.

  • Will, yes, that’s a doc bug, sorry. Because the Cacti graphs are not backwards compatible with the older project, and there is no older version/project at all for the Nagios checks, there’s nothing to say about upgrading. When the next release comes out, there will be some info on this topic.

  • I understand. Pro tip: in this case, DO NOT UPGRADE CACTI. See http://code.google.com/p/mysql-cacti-templates/issues/detail?id=197 this is one of the reasons I had to utterly break some things to work around a Cacti bug.

  • I’m actually running .87h now, but I found some patches in the forums to fix the issue in those bugs.

    Is it possible some kind of conversion script could be written to convert from the old version to the new?

  • Why didn’t you improve the Nagios plugins from PalominoDB? http://palominodb.com/about-us/projects

    There are already too many Nagios plugins for MySQL (I think Sheeri made a presentation about that) and most of them are fairly limited or don’t use any caching.

    I really do like the fact that Percona is working on monitoring and I really like the fact that the code is open.

  • Is SNMP access to the database enough for cacti monitoring? The old cacti templates didn’t have options for that so I had to use this: http://www.masterzen.fr/2010/01/10/mysql-snmp-10-snmp-monitoring-for-mysql/ to get it working. Only using SNMP is required in some high security environments (And SNMP is forbidden in other high security environments…)

  • Daniël, see my new blog post on why caching for fault detection is a bad idea.

    I think that an SNMP access method is a good idea to build too, but similarly to my previous comment, not for free.

  • We have been using check_mysql_health (and it’s cousins check_oracle_health, check_mssql_health and check_db2_health) since years and did not see any plugin with a feature list as complete as theirs.
    http://labs.consol.de/nagios/check_mysql_health/

  • In my opinion (backed by a lot of investigation into the causes of server downtime), that plugin monitors everything that causes noisy alerts and /dev/null email filters, and nothing that really indicates or causes actual problems in the server. I’m not ignorant of that plugin; I am building a better mousetrap. Much better.

  • hello,Baron Schwartz, i used xtrabackup for incremental backup , i used –salve-info to incremntal backup for convenience,but i found it always printing >> log scanned up to (0 1172823116) ,so the process of backup countn’t
    end , the xtrabackup_suspended file alse exist. when i drop the –salve-info option , the process of backup could be compelte soon.

  • I deployed the new plugin to monitor MySQL , the most graphs are normal, but the replication monitoring can’t display data in the graph template. the template is Graph Template: Percona MySQL Replication GT.
    please advise.

Leave a Reply

 
 

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.