Downloads

Blog

Contact Us

Manage Your Complex Database Environments with Percona Monitoring and Management (PMM)2 GA

September 19, 2019

Author

Dmitriy Kostiuk

Monitoring

Percona Software

Share this Post:

Percona Monitoring and Management 2 We are pleased to announce the General Availability of PMM2, our latest software release!

Created specifically to support open source software users, Percona Monitoring and Management (PMM) is a leading, free, open-source platform that allows you to actively manage and monitor the performance of your MySQL, MongoDB, and PostgreSQL database environments.

A recent Percona survey revealed that 41% of enterprises are running databases on multiple cloud providers and 61% of enterprises are running a combination of hybrid on-premises and cloud setups. Additionally, 92% of companies surveyed have more than one database in their environment, and 89% run more than one open-source database. Complex, multi-database, hybrid, and multi-cloud environments are a reality for many companies.

PMM provides a single pane of glass to manage your complex database environments in public, private, or on-premise environments. Our award-winning database monitoring tool has been built by database performance and scalability experts using best-of-breed tools. It is specifically designed to help DBAs and developers gain deep insight into their applications and databases and is used by thousands of organizations around the globe.

PMM allows users to do the following:

View historical data, trends, and analysis of your most critical applications and databases.
- Examine by default one month of metrics and queries at high resolution – don’t miss rapidly-oscillating conditions that can negatively impact performance.

Find database-specific queries that limit scalability and negatively impact your end-users quickly and efficiently.
- Query Analytics lets you leverage filters and labels to drill down on groups of servers.

Customize to reflect your specific workloads and environment – PMM can evolve with your applications and workloads.
- PMM collects data at different intervals based on the likelihood of the data experiencing a change, so the systems under observation are put under the least amount of load from PMM as possible. For example, MySQL server hostname will be collected every minute, however, MySQL Threads Running will be collected more aggressively.

Integrate with existing monitoring applications and frameworks, extending those platforms to include the top database monitoring tool on the market.
- Our new API makes it easier than ever to integrate with your existing configuration management system, easing the lifecycle management of systems and services in your environment.

Extend to add customer monitoring and database.
- PMM allows you to sample your database contents and build custom metric series so that you can plot activity that is meaningful to your application alongside your database metrics. This is available using the Custom Queries functionality for MySQL and PostgreSQL.
- PMM also provides for custom data collection for data collection outside of the database i.e. if you can script it, you can build a metric series. This is enabled by the textfile collector.

Our new PMM2 release introduces a number of enhancements and additional feature improvements, including:

Detailed query analytics and filtering technologies which enable you to identify issues faster than ever before.

A better user experience: Service-level dashboards give you immediate access to the data you need.

The new addition of PostgreSQL query tuning.

Enhanced security protocols to ensure your data is safe.

Our new API allows you to extend and interact with third-party tools.

PMM2 Feature Focus

Query Analytics featuring PostgreSQL

In response to demand, we’ve invested a lot of effort into bringing you an enhanced Query Analytics experience. With Query Analytics you’re able to examine the queries consuming the most amount of time across your entire fleet of servers, and then using filters and labels, drill down to find and isolate problematic queries requiring additional review. We’ve also added several long-awaited features such as:

Add multiple columns – see more than just load, query response time – want to examine MySQL InnoDB Rows Read, or PostgreSQL rows returned? You can add these columns, and more, to the table layout and see the aggregated values per query.

Sorting – you can now sort by any column. Want to know which query is reading the most amount of data via MySQL InnoDB Read Operations? Add the column, then sort by it.

Labeling – benefit from a variety of standard and custom labels in order to better categorize your servers. For example use Cluster or Replication Set to unify servers based on your topology. Or take advantage of the ability to define custom labels, for example, Availability Zone or Rack to define a physical location for your server instances.

PostgreSQL – In PMM2 you can visualize queries from PostgreSQL alongside your MySQL and MongoDB queries, and isolate them by selecting relevant filter options.

There is a filtering panel on the left, or use the search by bar to set filters using key:value syntax. For example, drill down to review just the queries related to pg2 service:

…or the detailed information about the selected query:

Rearranged dashboards and menu structure

PMM2 has the new taxonomy of the dashboards, which are now split up into the following groups:

Overview Dashboards provides a general view of all objects for the selected type (MySQL, OS, MongoDB, etc.).

Summary Dashboards are used for a more detailed view of the object.

Compare Dashboards show objects of the same type placed side-by-side allowing you to spot differences in their parameters, if any.

Details Dashboards supply you with more object-specific information.

Along with this rearrangement, we have a new simplified main menu. Below is the new look for its top-level:

Selecting a specific service (MySQL, MongoDB, PostgreSQL, etc.) will guide you to the next level of the hierarchy, where you can access a Service Compare Dashboard or one of the Details Dashboards related to this Service:

More on Service-level Dashboards

One of the most important navigational changes we’re making with PMM is how we approach visualizing your servers. We are calling these the Service-level dashboards and they are designed to give you a high-level overview of your fleets of servers by type of service. These dashboards provide summaries of important characteristics such as; number of Virtual CPUs, total disk space, number of instances, and more.

In the example below we show how you can navigate from the home dashboard to the MySQL Service dashboard, and then drill down to compare multiple nodes against each other:

PMM Inventory

PMM2 introduces a new data model, on which all objects visible to PMM are either nodes, services, or agents. These three types of objects together form an established hierarchy with Node at the top, then Service and Agents assigned to a Node. Using the new PMM Inventory Dashboard, you’ll be able to review associated objects to PMM Server. This dashboard contains three tabs for nodes, agents, and services:

API

We are pleased to provide an API which enables PMM to be used more easily and simply with popular configuration management tools such as Ansible, Chef, and Puppet. This API lets you programatically interact with PMM Server so that you can list, add, and remove services.

You can browse, explore, and even test the API using Swagger:

Using the API to execute commands is simple. The following example shows how to get a list of Nodes from PMM Server:

$ curl -k -u admin:admin -X POST "https://192.168.1.3/v1/inventory/Nodes/List"<br><br>{<br>  "generic": [<br>    {<br>      "node_id": "/node_id/c9672fa5-d9b4-4db0-9b40-ea8c2e3c800a",<br>      "node_name": "osboxes",<br>      "address": "10.0.2.15",<br>      "machine_id": "/machine_id/8b5f6f78e736e3e29ba6f1505c797297",<br>      "distro": "linux"<br>    },<br>    {<br>      "node_id": "pmm-server",<br>      "node_name": "pmm-server",<br>      "address": "127.0.0.1"<br>    }<br>  ]<br>}

1

$ curl -k -u admin:admin -X POST "https://192.168.1.3/v1/inventory/Nodes/List" { "generic": [ { "node_id": "/node_id/c9672fa5-d9b4-4db0-9b40-ea8c2e3c800a", "node_name": "osboxes", "address": "10.0.2.15", "machine_id": "/machine_id/8b5f6f78e736e3e29ba6f1505c797297", "distro": "linux" }, { "node_id": "pmm-server", "node_name": "pmm-server", "address": "127.0.0.1" } ] }

Read our guide on installing PMM2 to learn more.

Contacting Percona

We welcome any thoughts, comments, and suggestions you have on this latest software version.

Percona offers a range of open source software and services to help your business thrive and grow. Organizations interested in ensuring their databases perform at the highest level can also benefit from Percona Managed Services, Support, and Consulting.

To learn how Percona can help you make the most of your data, please contact us at 1-888-316-9775 or 0-800-051-8984 in Europe, or email [email protected]