0

Percona Monitoring and Management (PMM) 1.16.0 Is Now Available

Percona Monitoring and Management

PMM (Percona Monitoring and Management) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL® and MongoDB® servers to ensure that your data works as efficiently as possible.

Percona Monitoring and Management

While much of the team is working on longer-term projects, we were able to provide the following feature:

MySQL and PostgreSQL support for all cloud DBaaS providers – Use PMM Server to gather Metrics and Queries from remote instances!
Query Analytics + Metric Series – See Database activity alongside queries
Collect local metrics using node_exporter + textfile collector

We addressed 11 new features and improvements, and fixed 21 bugs.

MySQL and PostgreSQL support for all cloud DBaaS providers

You’re now able to connect PMM Server to your MySQL and PostgreSQL instances, whether they run in a cloud DBaaS environment, or you simply want Database metrics without the OS metrics.  This can help you get up and running with PMM using minimal configuration and zero client installation, however be aware there are limitations – there won’t be any host-level dashboards populated for these nodes since we don’t attempt to connect to the provider’s API nor are we granted access to the instance in order to deploy an exporter.

How to use

Using the PMM Add Instance screen, you can now add instances from any cloud provider (AWS RDS and Aurora, Google Cloud SQL for MySQL, Azure Database for MySQL) and benefit from the same dashboards that you are already accustomed to. You’ll be able to collect Metrics and Queries from MySQL, and Metrics from PostgreSQL.  You can add remote instances by selecting the PMM Add Instance item in a PMM group of the system menu:

https://github.com/percona/pmm/blob/679471210d476a5e98d26a632318f1680cfd98a2/doc/source/.res/graphics/png/metrics-monitor.menu.pmm1.png?raw=true

where you will then have the opportunity to add a Remote MySQL or Remote PostgreSQL instance:

You’ll add the instance by supplying just the Hostname, database Username and Password (and optional Port and Name):

metrics-monitor.add-remote-mysql-instance.png

Also new as part of this release is the ability to display nodes you’ve added, on screen RDS and Remote Instances:

metrics-monitor.add-rds-or-remote-instance1.png

Server activity metrics in the PMM Query Analytics dashboard

The Query Analytics dashboard now shows a summary of the selected host and database activity metrics in addition to the top ten queries listed in a summary table.  This brings a view of System Activity (CPU, Disk, and Network) and Database Server Activity (Connections, Queries per Second, and Threads Running) to help you better pinpoint query pileups and other bottlenecks:

https://raw.githubusercontent.com/percona/pmm/86e4215a58e788a8ec7cb1ebe679e1593c484078/doc/source/.res/graphics/png/query-analytics.png

Extending metrics with node_exporter textfile collector

While PMM provides an excellent solution for system monitoring, sometimes you may have the need for a metric that’s not present in the list of node_exporter metrics out of the box. There is a simple method to extend the list of available metrics without modifying the node_exporter code. It is based on the textfile collector.  We’ve enabled this collector as on by default, and is deployed as part of linux:metrics in PMM Client.

The default directory for reading text files with the metrics is /usr/local/percona/pmm-client/textfile-collector, and the exporter reads files from it with the .prom extension. By default it contains an example file example.prom which has commented contents and can be used as a template.

You are responsible for running a cronjob or other regular process to generate the metric series data and write it to this directory.

Example – collecting docker container information

This example will show you how to collect the number of running and stopped docker containers on a host. It uses a crontab task, set with the following lines in the cron configuration file (e.g. in /etc/crontab):

*/1* * * * root echo -n “” > /tmp/docker_all.prom; docker ps -a -q | wc -l | xargs echo node_docker_containers_total >> /usr/local/percona/pmm-client/docker_all.prom;
*/1* * * * root echo -n “” > /tmp/docker_running.prom; docker ps | wc -l | xargs echo node_docker_containers_running_total >> /usr/local/percona/pmm-client/docker_running.prom;

The result of the commands is placed into the docker_all.prom and docker_running.prom files and read by exporter and will create two new metric series named node_docker_containers_total and node_docker_containers_running_total, which we’ll then plot on a graph:

pmm 1.16

New Features and Improvements

PMM-3195 Remove the light bulb

PMM-3194 Change link for “Where do I get the security credentials for my Amazon RDS DB instance?”

PMM-3189 Include Remote MySQL & PostgreSQL instance logs into PMM Server logs.zip system

PMM-3166 Convert status integers to strings on ProxySQL Overview Dashboard – Thanks,  Iwo Panowicz for  https://github.com/percona/grafana-dashboards/pull/239

PMM-3133 Include Metric Series on Query Analytics Dashboard

PMM-3078 Generate warning “how to troubleshoot postgresql:metrics” after failed pmm-admin add postgresql execution

PMM-3061 Provide Ability to Monitor Remote MySQL and PostgreSQL Instances

PMM-2888 Enable Textfile Collector by Default in node_exporter

PMM-2880 Use consistent favicon (Percona logo) across all distribution methods

PMM-2306 Configure EBS disk resize utility to run from crontab in PMM Server

PMM-1358 Improve Tooltips on Disk Space Dashboard – thanks, Corrado Pandiani for texts

Fixed Bugs

PMM-3202 Cannot add remote PostgreSQL to monitoring without specified dbname

PMM-3186 Strange “Quick ranges” tag appears when you hover over documentation links on PMM Add Instance screen

PMM-3182 Some sections for MongoDB are collapsed by default

PMM-3171 Remote RDS instance cannot be deleted

PMM-3159 Problem with enabling RDS instance

PMM-3127 “Expand all” button affects JSON in all queries instead of the selected one

PMM-3126 Last check displays locale format of the date

PMM-3097 Update home dashboard to support PostgreSQL nodes in Environment Overview

PMM-3091 postgres_exporter typo

PMM-3090 TLS handshake error in PostgreSQL metric

PMM-3088 It’s possible to downgrade PMM from Home dashboard

PMM-3072 Copy to clipboard is not visible for JSON in case of long queries

PMM-3038 Error adding MySQL queries when options for mysqld_exporters are used

PMM-3028 Mark points are hidden if an annotation isn’t added in advance

PMM-3027 Number of vCPUs for RDS is displayed incorrectly – report and proposal from Janos Ruszo

PMM-2762 Page refresh makes Search condition lost and shows all queries

PMM-2483 LVM in the PMM Server AMI is poorly configured/documented – reported by Olivier Mignault  and lot of people involved.  Special thanks to  Chris Schneider for checking with fix options

PMM-2003 Delete all info related to external exporters on pmm-admin list output

How to get PMM Server

PMM is available for installation using three methods:

Docker Hub – docker pull percona/pmm-server – Documentation

AWS Marketplace – Documentation

Open Virtualization Format (OVF) – Documentation

Help us improve our software quality by reporting any Percona Monitoring and Management bugs you encounter using our bug tracking system.

Read more: percona.com

Filed in: Special Needs Tags: , , , ,

Get Updates

Share This Post

Recent Posts

Leave a Reply

Submit Comment
© 2018 Your Child Learning. All rights reserved.