PMM 2.2 Released with Full Support for Amazon RDS and Aurora

Percona Monitoring and Management 2.2 (PMM) was released on December 24th with new features and updates designed to help you more easily manage and monitor your open source databases across your multi-cloud and hybrid-cloud environments. Let’s take a look at a few of the most interesting ones.   

Full Support for AWS RDS for MySQL/MariaDB and AWS Aurora MySQL-Based Instances

We have added full support for AWS RDS for MySQL, AWS RDS for MariaDB, and AWS Aurora MySQL instances so that you no longer have to add them as remote instances (although you still have this option). To do this, you can run discovery on your AWS account and see the list of supported RDS instances to be added for monitoring.

AWS RDS for MySQL/MariaDB

AWS Aurora MySQL

Additionally, you can use alternative partitions for discovery like Gov or China partitions. You can read more on how to do this in the Percona Monitoring and Management FAQ.  

After discovery, you use the same familiar UI to add RDS instances to be monitored. 

Once you’ve added your instances you’ll get them monitored for MySQL and RDS metrics sourced from the AWS CloudWatch service API. For more, read how to properly set the parameters on the AWS side

Once this has all been done, you’ll see a lot more detailed information about your RDS instances in the PMM dashboards.

 MySQL Amazon Aurora

PMM Node Summary

New Settings Page

PMM Settings

We have also added the capability to configure your PMM server parameters via the UI (not just via API).  The new PMM Settings UI provides you with the ability to change the following:

PMM Settings UI

  • Metrics Resolution from Low to High. This will adjust how often data will be collected from your services.   
  • Data Retention is defining the time period of how long data will be kept in PMM and when it will be deleted. It’s 30 days by default.  
  • You can turn ON/OFF the Call Home and Updates. These options allow you to get information from Percona about a new version of PMM and be able to update your server from the Home dashboard Update widget.  
  • You can now upload your own SSH key enabling you to log in to virtual appliances externally. (primarily for use with our OVF distribution, while also useful for AWS Marketplace deployments) For more details, please visit PMM Server as a Virtual Appliance.
      

There is also a section where you can download diagnostics data to simplify troubleshooting PMM issues. By pressing the button you’ll get an archive with logs and config files from your PMM Server. Make sure you add this archive when you report PMM bugs in Jira for Percona. 

User Interface Improvements

We have improved the Query Analytics page enabling you to be able to see all of the labels in your system and have provided the capability to select multiple items for filtering. 

PMM improved the Query Analytics

  • We upgraded to Granafa v6.5.1 so you can leverage the latest available features. 
  • On some dashboards, like MySQL Services Overview, we added drill-down lists to let you click on some values on the Graph and easily transition to the related dashboard. For example about Mysql Service or Node Summary:  

MySQL Sorts

Finally, we turned on an additional data collection point that will be available once you update your pmm2-client package:

  • Activated ‘hwmon‘ metrics to expose hardware monitoring and sensor data from /sys/class/hwmon/. While these are not presented by default in any dashboards, they are available for you to use in your own dashboards.

PMM 2.2 Can Now be Deployed on VMWare, VirtualBox, and Will be Available Soon on the AWS Marketplace  

Customers can now deploy PMM 2.2 on the latest versions of VMWare (vSphere and ESXi) and Virtual box using our OVF images which are available at our PMM Download page.  Just select  “Software” = “Virtual Appliance OVF”  and you’ll get the link for the OVA file. 

download percona monitoring and management

PMM 2.2 is now available on Amazon AWS Marketplace.  More details to help you get started will be coming soon.

For a full list of new features and bug fixes included in PMM 2.2, see our release notes and for more information on Percona Monitoring and Management, visit our PMM webpage.

Share this post

Comments (2)

  • Sids Reply

    @terrri, new features are great.
    Can you tell me why exactly external exporter was dropped from pmm2 which was available in pmm1?!
    Are there any plans for external exporters in future versions of pmm?! We hugely rely on external metrics to monitor other databases from pmm1.

    January 3, 2020 at 9:38 pm
    • Roma Novikov Reply

      Hi Sids. Thanks for using PMM!
      The External exporters in PMM2 one of the top features we are planning to work very soon.
      BTW, just curious and for our internal statistics: What DB or system you’ve connected to PMM by External exporter?

      January 6, 2020 at 3:59 am

Leave a Reply