November 26, 2014

Introducing the pmp-check-mysql-status Nagios Plugin

Most of the Nagios plugins included with the Percona Monitoring Plugins are purpose-built for specific scenarios that I found in my research to be frequent, severe, or subtle causes of problems in MySQL systems. They are intentionally not generic because I wanted to focus on doing one thing with each plugin, and doing it excellently. […]

How to Monitor MySQL with Percona’s Nagios Plugins

In this post, I’ll cover the new MySQL monitoring plugins we created for Nagios, and explain their features and intended purpose. I want to add a little context. What problem were we trying to solve with these plugins? Why yet another set of MySQL monitoring plugins? The typical problem with Nagios monitoring (and indeed with […]

Why don’t our new Nagios plugins use caching?

In response to the release of our new MySQL monitoring plugins on Friday, one commenter asked why the new Nagios plugins don’t use caching. It’s worth answering in a post rather than a comment, because there is an important principle that needs to be understood to monitor servers correctly. But first, some history. When I […]

Log rotate and the (deleted) MySQL log file mystery

Did your logging stop working after you set up logrotate? Then this post might be for you. Some time ago, Peter Boros wrote about Rotating MySQL Slow Logs safely, explaining the steps of a “best practice” log rotate/archive. This post will add more info about the topic. When running logrotate for MySQL (after proper setting […]

Galera data on Percona Cloud Tools (and other MySQL monitoring tools)

I was talking with a Percona Support customer earlier this week who was looking for Galera data on Percona Cloud Tools. (Percona Cloud Tools, now in free beta, is a hosted service providing access to query performance insights for all MySQL uses.) The customer mentioned they were already keeping track of some Galera stats on Cacti, and […]

Percona Monitoring Plugins 1.1.4 release

Percona is glad to announce the release of Percona Monitoring Plugins 1.1.4. Changelog: * Added login-path support to Nagios plugins with MySQL client 5.6 (bug 1338549) * Added a new threshold option for delayed slaves to pmp-check-mysql-replication-delay (bug 1318280) * Added delayed slave support to pmp-check-mysql-replication-running (bug 1332082) * Updated Nagios plugins and Cacti script […]

percona-millipede – Sub-second replication monitor

I recently helped a client implement a custom replication delay monitor and wanted to share the experience and discuss some of the iterations and decisions that were made. percona-millipede was developed in conjunction with Vimeo with the following high-level goal in mind: implement a millisecond level replication delay monitor and graph the results.  Please visit […]

Percona Monitoring Plugins 1.1.3. Addressed CVE-2014-2569.

Percona is glad to announce the release of Percona Monitoring Plugins 1.1.3. Changelog: * Introduced more secure location of PHP script configs to harden a Cacti setup * Addressed CVE-2014-2569 We have introduced a more secure location /etc/cacti/ for PHP script configs. Earlier, the only way was to keep .php.cnf configs inside of scripts/ folder […]

Percona Monitoring Plugins 1.1.2, now with Amazon RDS support

Percona is glad to announce the release of Percona Monitoring Plugins 1.1.2. Changelog: * Added Nagios plugin and Cacti template for Amazon RDS * Added Nagios config template to the documentation * Added an option to pmp-check-pt-table-checksum to check MAX(ts) of latest checksum * Added generic Nagios plugin for PT tables * Extended pmp-check-mysql-processlist with […]

Percona XtraDB Cluster performance monitoring and troubleshooting

First of all we would like to thank all of you who attended the Feb. 19 MySQL webinar, “Performance Monitoring and Troubleshooting of Percona XtraDB Cluster.” We got some really good questions – many of which we didn’t have time to address during the sessions, so Johan Andersson, Severalnines CTO,and I are answering them here […]