Percona Monitoring and Management 2.16.0

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

Important note for users of PMM 2.16.0

If you started using PMM from version 2.16 and have already upgraded to 2.17, 2.18, or 2.19, you might have some problems with PMM Server monitoring, Remove Monitoring, or RDS/Azure monitoring. If you experience a problem, we recommend you upgrade and replace the Docker container by following the official instructions for an upgrade here: https://www.percona.com/doc/percona-monitoring-and-management/2.x/setting-up/server/docker.html#upgrade.

If you can't do this, then you need to perform additional steps after upgrading to 2.20.

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

Release Highlights

• Amazon RDS PostgreSQL monitoring

  AWS monitoring in PMM now covers PostgreSQL RDS and PostgreSQL Aurora types. PMM will include them in a Discovery UI where they can be added which will result in node related metrics as well as PostgreSQL database performance metrics. Before this release, this was available only to MySQL-related instances from Amazon RDS.

• Azure Discovery and Node metrics extraction

  Technical Preview: PMM will have the same level of support for Microsoft Azure Database as a Service (DBaaS) as we have for AWS's DBaaS (RDS/Aurora on MySQL or PostgreSQL). You will be able to easily discover and add Azure databases for monitoring by PMM complete with node-level monitoring. This feature is available only if you explicitly activate it on the PMM Settings page. Deactivating it will not remove added services from monitoring, but will just hide the ability to discover and add new Microsoft Azure Services.

  (This is a feature technical preview because we want to release it as soon as possible to get feedback from users. We are expecting to do more work on this feature to make it more API and resource efficient.)

• Security Threat Tool Scheduling - Manage execution and execution intervals

  Security Threat Tool users are now able to control the Security Check execution time intervals for groups of checks, move checks between groups, and disable individual checks if necessary.

• Support for pg_stat_monitor 0.8

  Added compatibility with pg_stat_monitor plugin v 0.8.0. This is not exposing the new features for the plugin in PMM yet, but ensures Query Analytics metrics are collected to the same degree it was with version 0.6.0 of the plugin.

• Consistent support of Technical Preview Features

  Reworked the PMM Settings page to make it clear what features are in Technical Preview vs General Availability (GA) and to simplify activation/deactivation of technical preview features. We also provide a better definition of what a Technical Preview is.

• Migration of Settings and other service pages in PMM from Grafana dashboards

  The PMM Settings page and several others (including Add Instance and Inventory) are being converted to Grafana pages and will no longer be presented as dashboards. Additionally, we're moving the menu to the sidebar navigation for consistency and more flexibility compared to the older menu structure.

• Integrated Alerting improvements

  We released the next stage of improvements in Integrated Alerting functionality of PMM to simplify the usage of the feature. Together with improvements, we continue fixing known bugs in this feature.

• [DBaaS] Resource planning and prediction (Resource calculator)

  Technical preview: While creating a DB cluster a user can see a prediction of the resources this cluster will consume with all components as well as the current total and available resources in the K8s. Users will be warned that if they attempt to create a DB cluster it may be unsuccessful because of available resources in the K8s.

• [DBaaS] PSMDB 1.7.0 operator support

  DBaaS in PMM will be using the recently-released Percona Kubernetes Operator for Percona Server for MongoDB 1.7.0 to create MongoDB clusters.

New Features

• PMM-7313, PMM-7610: Ability to discover and monitor Amazon RDS PostgreSQL instances with collecting PostgreSQL and RDS node metrics (Thanks to Daniel Guzman Burgos for reporting this issue).
• PMM-7345: Expose metrics for all available databases on a PMM monitored PostgreSQL server.
• PMM-7344: Update postgres_exporter version from 0.4.6 to 0.8.0. (See the full list of improvements in the changelog.)
• PMM-7767, PMM-7696: Implement feature flag to enable Microsoft Azure monitoring. Users can use the UI or set an environment variable (ENABLE_AZUREDISCOVER=1) during container creation.
• PMM-7684, PMM-7498: Ability to discover running and supported Microsoft Azure Databases instances in a provided account.
• PMM-7678, PMM-7679, PMM-7676, PMM-7499, PMM-7691: Prepare, modify and use azure_exporter to collect Node related metrics.
• PMM-7681: Use Microsoft Azure metrics on Node/OS-related dashboards to show the metrics on panels.
• PMM-7339: Security Threat Tool: Ability to execute security checks individually and on-demand.
• PMM-7451, PMM-7337: Security Threat Tool: Ability to change intervals for security checks on the PMM Settings page.
• PMM-7772, PMM-7338: Security Threat Tool: Ability to change default execution interval per check.
• PMM-7336: Security Threat Tool: Execute checks based on execution interval they belong to.
• PMM-7335: Security Threat Tool: Ship security check files with predefined execution interval.
• PMM-7748: Add an additional experimental menu for Dashboards on the left side panel.
• PMM-7688: Unify UX and layout of all PMM specific pages like Settings, Add Instance etc.
• PMM-7687: Modify links in menus to ensure both menus are working as expected after dashboard URL change.
• PMM-7705: Simplify display of features in technical preview to easily identify them and their current state.
• PMM-7522, PMM-7511: Integrated Alerting: Improve Notification Channels UX by Pagination for the Notification list.
• PMM-7521, PMM-7510: Integrated Alerting: Improve Alert Rule Templates UX by Pagination on Rule Templates list.
• PMM-7652, PMM-7674, PMM-7503, PMM-7486: DBaaS: While creating the DB cluster see all and available resources in the K8s cluster, such as Disk, CPU & Memory.
• PMM-7508, PMM-7488: DBaaS: See predicted resource usage for selected DB Cluster configuration.
• PMM-7364: DBaaS: Show warning before starting creating the cluster if there are not enough resources in the K8s cluster to create DB Cluster with requested configuration.
• PMM-7580, PMM-7359: DBaaS: Users can select the database version to use during DB Cluster creation.

Improvements

• PMM-7506: Security Threat Tool: Reduce False Positives due to Roles automatically created in PXC with no password but cannot be used to login.
• PMM-7569: Make PMM compatible with pg_stat_monitor 0.8 release.
• PMM-7571: Modified Percona Platform Account registration flow from PMM server UI.
• PMM-7513: Integrated Alerting: Ability to see default values and Threshold values during the Alert Rule creation.
• PMM-7461: Integrated Alerting: Improve UX of tables presentation and loading on UI.
• PMM-7375: Integrated Alerting: Inform users about the template that they are editing and warn them about the limitations.
• PMM-7260: Integrated Alerting: Make it clearer what rule is being edited.

Bugs Fixed

• PMM-7131, PMM-7555: QAN for PostgreSQL attempts to connect to a database with the same name as the username. (Thanks to Daniel Guzman Burgos for reporting this issue)
• PMM-7481: Query Analytics is not showing “Query with Errors” in the Profile section.
• PMM-7464: NGINX misconfiguration leads to log storm in push mode
• PMM-7434: Integrated Alerting: Unknown parameters [threshold] error during Add/Update Alert Rule.
• PMM-7231: Integrated Alerting: Disabling channels does nothing.
• PMM-7379: Integrated Alerting: Can not edit Alert Rule Name through API.
• PMM-7232: Integrated Alerting: Disabling IA does not disable rules evaluation and notifications sending.
• PMM-7119: Integrated Alerting: Update error notification for adding/update Alert rule Template – There was inconsistent behavior if you tried to add a new Rule Template with an already-used name.
• PMM-7543: Integrated Alerting: selected section disappears from a breadcrumb after clicking the tab for a second time.
• PMM-7766: DBaaS: PMM Upgrade breaks DBaaS get credentials method.
• PMM-7351: DBaaS: Safari does not accept float numbers as a custom option in the “Create Cluster” dialogue.
• PMM-7701: DBaaS: PSMDB clusters stuck in initializing due to special characters in secrets.