Percona Monitoring and Management 2.20.0

Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance.

Release Highlights

• The Easy-install script for PMM Server is checksum verified.
• PMM will use Grafana 7.5 instead of 7.3. We are also preparing for Grafana 8.
• PostgreSQL monitoring with the pg_stat_monitor plugin enabled exposes new metrics such as Plan Times, WAL Fpi/Bytes/Records.
• For users who deploy PMM Server through the AWS Marketplace, AWS RDS service discovery will be executed without AWS credentials and tuning IAM roles.
• For Backup Management (Technical Preview), we added the ability to schedule backups so you can schedule and see already scheduled backups in the UI.

Important note for users of PMM who started out using the Docker image of 2.16.0

If you installed PMM version 2.16 as a new Docker image and have since used the home dashboard upgrade widget to upgrade to any of 2.17, 2.18, or 2.19, you might experience problems with monitoring the PMM server itself, Remote Monitoring, or RDS/Azure monitoring. If you experience any of these problems, you can simply run the following commands to get your instance working and it will be automatically resolved in the next release:

1. Enter the container: docker exec -it pmm-server bash
2. Roll back pmm2-client package to stable version: yum downgrade -y pmm2-client

Alternatively, you can replace the existing Docker container with a fresh install of the latest release by following the official instructions for an upgrade. (This will guide you through taking a backup of your PMM Server and restoring it after installing a fresh docker image of PMM Server.)

New Features

• PMM-8157: Backup Management: Show scheduled backups – A new view that shows the list of scheduled backups with quick actions to enable/disable, edit, copy, and delete.
• PMM-8155: Backup Management: Scheduling of backups – Support for Backup Scheduling has been added so that users can define backup jobs to run automatically in the future with the option of making the schedules recurring.
• PMM-7010: Option to unregister current node (pmm-admin unregister)

Improvements

• PMM-7552: PMM Server Docker image: Add labels to PMM Server Docker image (Thanks to Nicolas for reporting this issue)
• PMM-8266: PMM Server Docker image: Decommission and remove Prometheus binaries and configuration
• PMM-8040: PMM Server Docker image: Remove yum cache to reduce size of image
• PMM-7809: Grafana upgrade from 7.3.7 to 7.5.7 – Read more at grafana.com
• PMM-8386: Overview text on the Home page is missing PostgreSQL as a supported technology
• PMM-7722: DBaaS: Announce new supported version of operator – Shows that a new version of the operator is available.
• PMM-6278: Modification of MySQL 'Delete' queries to provide 'Explain' information
• PMM-8468: Forbid the use of outdated ciphers for HTTPS protocol on exporters
• PMM-7649: Security Checks: Show "Insufficient access permissions" in UI for non admin users
• PMM-8059: Update Query Analytics UI to clarify estimated results on MySQL 'explain' response where we modified original query
• PMM-8043: Return Service Name in GetCheckResults API response
• PMM-8000: Expose new numbered metrics available in pg_stat_monitor 0.9

Bugs Fixed

• PMM-8299: Backup Management: Remove storage location shows wrong notification – When removing a storage location, PMM presents misleading information to the user in the form of two notification messages for both error and success.
• PMM-8283: Backup Management: Error when removing location with 'force delete' option
• PMM-8064: Dashboards: Size of Temp Files Report Metric value has wrong unit on PostgreSQL Instance Summary Dashboard
• PMM-6981: Dashboards: Wrong version is shown for MariaDB services
• PMM-7738: Integrated Alerting: Alerts for some built-in templates missing service name label
• PMM-6877: mongodb_exporter doesn't recognize being on a mongos host and fills the syslog with replSetGetStatus errors (Thanks to Clyde Shillingford for reporting this issue)
• PMM-7627: Consistent PMM Server log management – Adds consistency to the log management of nginx, postgresql and clickhouse-server, which is now delegated to supervisord. Removes the logrotate daemon from the image.
• PMM-8492: PMM Client version is 2.21.0 inside PMM Server after upgrade from 2.16.0

Known Issues (unfixed problems that you should be aware of)

• PMM-8414: Backup Scheduler not working if user specifies explicit job start time