Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL® and MongoDB® 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.
We focused mainly on two features in 1.10.0, but there are also several notable improvements worth highlighting:
[LIST]
[]Annotations – Record and display Application Events as Annotations using pmm-admin annotate
[]Grafana 5.0 – Improved visualization effects
[]Switching between Dashboards – Restored functionality to preserve host when switching dashboards
[]New Percona XtraDB Cluster Overview graphs – Added Galera Replication Latency graphs on Percona XtraDB Cluster Overview dashboard with consistent colors
[/LIST]
The issues in the release include four new features & improvements, and eight bugs fixed. Annotations
Application events are one of the contributors to changes in database performance characteristics, and in this release PMM now supports receiving events and displaying them as Annotations using the new command pmm-admin annotate. A recent Percona survey reveals that Database and DevOps Engineers highly value visibility into the Application layer. By displaying Application Events on top of your PMM graphs, Engineers can now correlate Application Events (common cases: Application Deploys, Outages, and Upgrades) against Database and System level metric changes.
Usage
For example, you have just completed an Application deployment to version 1.2, which is relevant to UI only, so you want to set tags for the version and interface impacted:
[TABLE]
[TR]
[TD]1[/TD]
[TD]pmm-admin annotate “Application deploy v1.2” --tags “UI, v1.2”[/TD]
[/TR]
[/TABLE]
Using the optional --tags allows you to filter which Annotations are displayed on the dashboard via a toggle option. Read more about Annotations utilization in the Documentation. Grafana 5.0
We’re extremely pleased to see Grafana ship 5.0 and we were fortunate enough to be at Grafanacon, including Percona’s very own Dimitri Vanoverbeke (Dim0) who presented What we Learned Integrating Grafana and Prometheus!
What we Learned Integrating Grafana with Prometheus
Included in Grafana 5.0 are a number of dramatic improvements, which in future Percona Monitoring and Management releases we plan to extend our usage of each feature, and the one we like best is the virtually unlimited way you can size and shape graphs. No longer are you bound by panel constraints to keep all objects at the same fixed height! This improvement indirectly addresses the visualization error in PMM Server where some graphs would appear to be on two lines and ended up wasting screen space.
Switching between Dashboards
PMM now allows you to navigate between dashboards while maintaining the same host under observation, so that for example you can start on MySQL Overview looking at host serverA, switch to MySQL InnoDB Advanced dashboard and continue looking at serverA, thus saving you a few clicks in the interface. New Percona XtraDB Cluster Galera Replication Latency Graphs
We have added new Percona XtraDB Cluster Replication Latency graphs on our Percona XtraDB Cluster Galera Cluster Overview dashboard so that you can compare latency across all members in a cluster in one view.
Issues in this release[/h] [h=4]New Features & Improvements
[LIST]
[]PMM-2330 – Application Annotations DOC Update
[]PMM-2332 – Grafana 5 DOC Update
[]PMM-2293 – Add Galera Replication Latency Graph to Dashboard PXC/Galera Cluster Overview RC Ready
[]PMM-2295 – Improve color selection on Dashboard PXC/Galera Cluster Overview RC Ready
[/LIST]Bugs fixed
[LIST]
[]PMM-2311 – Fix misalignment in Query Analytics Metrics table RC Ready
[]PMM-2341 – Typo in text on password page of OVF RC Ready
[]PMM-2359 – Trim leading and trailing whitespaces for all fields on AWS/OVF Installation wizard RC Ready
[]PMM-2360 – Include a “What’s new?” link for Update widget RC Ready
[]PMM-2346 – Arithmetic on InnoDB AHI Graphs are invalid DOC Update
[]PMM-2364 – QPS are wrong in QAN RC Ready
[]PMM-2388 – Query Analytics does not render fingerprint section in some cases DOC Update
[]PMM-2371 – Pass host when switching between Dashboards
[/LIST]How to get PMM
PMM is available for installation using three methods:
[LIST]
[]On Docker Hub – docker pull percona/pmm-server – Documentation
[]AWS Marketplace – Documentation
[*]Open Virtualization Format (OVF) – Documentation
[/LIST]
Help us improve our software quality by reporting any Percona Monitoring and Management bugs you encounter using our bug tracking system.