Percona Monitoring Plugins

Percona Monitoring and Management: Look After Your pmm-data Container

looking after pmm-datamcontainers

If you have already deployed PMM server using Docker you might be aware that we begin by creating a special container for persistent PMM data. In this post, I aim to explain the importance of pmm-data container when you deploy PMM server with Docker. By the end of this post, you will have a […]

Read more

Percona Monitoring Plugins 1.1.8 Release Is Now Available

Percona Monitoring Plugins 1.1.7

Percona announces the release of Percona Monitoring Plugins 1.1.8.
Changelog

Add MySQL 5.7 support
Changed a canary check to use timestamp.now() and return a timedelta.seconds
Remove an additional condition for the Dictionary memory allocated
Fixed a false-positive problem when the calculated delay was less than 0 and the -m was not set.
Fixed the problem where slaves would alert due to deadlocks […]

Read more

Monitoring Databases: A Product Comparison

Monitoring Databases PMM small

In this blog post, I will discuss the solutions for monitoring databases (which includes alerting) I have worked with and recommended in the past to my clients. This survey will mostly focus on MySQL solutions. 
One of the most common issues I come across when working with clients is monitoring and alerting. Many times, companies […]

Read more

Webinar Thursday, January 12: Percona Software News and Roadmap Update for Q1 2017

Please join Percona CEO Peter Zaitsev for a webinar on Thursday, January 12, 2017 at 11 am PST/ 2 pm EST (UTC-8) for a discussion on the Percona Software News and Roadmap Update for Q1 2017.
In this webinar, Peter will discuss what’s new in Percona open source software. This will include Percona Server for […]

Read more

Percona Monitoring Plugins 1.1.7 release

Percona Monitoring Plugins 1.1.7

Percona announces the release of Percona Monitoring Plugins 1.1.7.
Changelog

New Nagios script pmp-check-mongo.py for MongoDB.
Added MySQL socket and flag options to Cacti PHP script.
Added disk volume check on “Mounted on” in addition to “Filesystem” to Cacti PHP script to allow monitoring of tmpfs mounts.
Allow delayed slave to have SQL thread stopped on pmp-check-mysql-replication-delay check.
Fix for […]

Read more

Percona Monitoring Plugins 1.1.6 release

Percona Monitoring Plugins

Percona is glad to announce the release of Percona Monitoring Plugins 1.1.6.
Changelog:

Added new RDS instance classes to RDS scripts.
Added boto profile support to RDS scripts.
Added AWS region support and ability to specify all regions to RDS scripts.
Added ability to set AWS region and boto profile on data source level in Cacti.
Added period, average time […]

Read more

Percona Monitoring Plugins 1.1.5 release

Percona is glad to announce the release of Percona Monitoring Plugins 1.1.5.
Changelog:

Added more DB instance classes to pmp-check-aws-rds.py (issue 1398911)
Added configurable query period and average time to pmp-check-aws-rds.py (issue 1436943)
Added region support to pmp-check-aws-rds.py (issue 1442980)
Added an option to alert when server is not configured as replica to pmp-check-mysql-replication-delay (issue 1357017)
Added an option to […]

Read more

Tips from the trenches for over-extended MySQL DBAs

This post is a follow-up to my November 19 webinar, “Tips from the Trenches: A Guide to Preventing Downtime for the Over-Extended DBA,” during which I described some of the most common reasons DBAs experience avoidable downtime. The session was aimed at the “over-stretched DBA,” identified as the MySQL DBA short of time or […]

Read more

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.
Archive your log files!
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 […]

Read more

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 to leverage lock-free SHOW […]

Read more