We are pleased to announce the launch of PMM 2.0.0-alpha2, Percona’s second Alpha release of our long-awaited PMM 2 project! In this release, you’ll find support for MongoDB Metrics and Query Analytics – watch for sharp edges as we expect to find a lot of bugs! We’ve also expanded our existing support of MySQL from our first Alpha to now include MySQL Slow Log as a data source for Query Analytics, which enhances the Query Detail section to include richer query metadata.
- MongoDB Metrics – You can now launch PMM 2 against MongoDB and gather metrics and query data!
- MongoDB Query Analytics – Data source from MongoDB Profiler is here!
- MySQL Query Analytics
- Queries source – MySQL Slow Log is here!
- Sorting and more columns – fixed a lot of bugs around UI
PMM 2 is still a work in progress – expect to see bugs and other missing features! We are aware of a number of issues, but please report any and all that you find to Percona’s JIRA.
This release is not recommended for Production environments. PMM 2 Alpha is designed to be used as a new installation – please don’t try to upgrade your existing PMM 1 environment.
MongoDB Query Analytics
We’re proud to announce support for MongoDB Query Analytics in PMM 2.0.0-alpha2!
Using filters you can drill down on specific servers (and other fields):
MongoDB Metrics
In this release we’re including support for MongoDB Metrics, which means you can add a local or remote MongoDB instance to PMM 2 and take advantage of the following view of MongoDB performance:
MySQL Query Analytics Slow Log source
We’ve rounded out our MySQL support to include Slow log – and if you’re using Percona Server with the Extended Slow Log format, you’ll be able to gain deep insight into the performance of individual queries, for example, InnoDB behavior. Note the difference between the detail available from PERFORMANCE_SCHEMA vs Slow Log:
PERFORMANCE_SCHEMA:
Slow Log:
Installation and configuration
The default PMM Server credentials are:
username: admin
password: admin
Install PMM Server with docker
The easiest way to install PMM Server is to deploy it with Docker. You can run a PMM 2 Docker container with PMM Server by using the following commands (note the version tag of 2.0.0-alpha2):
1 2 | docker create -v /srv --name pmm-data-2-0-0-alpha2 perconalab/pmm-server:2.0.0-alpha2 /bin/true docker run -d -p 80:80 -p 443:443 --volumes-from pmm-data-2-0-0-alpha2 --name pmm-server-2.0.0-alpha2 --restart always perconalab/pmm-server:2.0.0-alpha2 |
Install PMM Client
Since PMM 2 is still not GA, you’ll need to leverage our experimental release of the Percona repository. You’ll need to download and install the official percona-release package from Percona, and use it to enable the Percona experimental component of the original repository. See percona-release official documentation for further details on this new tool.
Specific instructions for a Debian system are as follows:
1 2 | wget https://repo.percona.com/apt/percona-release_latest.generic_all.deb sudo dpkg -i percona-release_latest.generic_all.deb |
Now enable the correct repo:
1 2 | sudo percona-release disable all sudo percona-release enable original experimental |
Now install the pmm2-client package:
1 2 | apt-get update apt-get install pmm2-client |
Users who have previously installed pmm2-client alpha1 version should remove the package and install a new one in order to update to alpha2.
Please note that having experimental packages enabled may affect further packages installation with versions which are not ready for production. To avoid this, disable this component with the following commands:
1 2 | sudo percona-release disable original experimental sudo apt-get update |
Configure PMM
Once PMM Client is installed, run the pmm-admin setup command with your PMM Server IP address to register your Node within the Server:
1 | # pmm-agent setup --server-insecure-tls --server-address=<IP Address>:443 |
We will be moving this functionality back to pmm-admin config in a subsequent Alpha release.
You should see the following:
1 2 3 4 5 6 7 | Checking local pmm-agent status... pmm-agent is running. Registering pmm-agent on PMM Server... Registered. Configuration file /usr/local/percona/pmm-agent.yaml updated. Reloading pmm-agent configuration... Configuration reloaded. |
Adding MySQL Metrics and Query Analytics (Slow Log source)
The syntax to add MySQL services (Metrics and Query Analytics) using the new Slow Log source:
1 | sudo pmm-admin add mysql --use-slowlog --username=pmm --password=pmm |
where username and password are credentials for accessing MySQL.
Adding MongoDB Metrics and Query Analytics
You can add MongoDB services (Metrics and Query Analytics) with the following command:
1 | pmm-admin add mongodb --use-profiler --use-exporter --username=pmm --password=pmm |
You can then check your MySQL and MongoDB dashboards and Query Analytics in order to view your server’s performance information!
We hope you enjoy this release, and we welcome your comments on the blog!
About PMM
Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL®, MongoDB®, and PostgreSQL performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL®, MongoDB®, and PostgreSQL® servers to ensure that your data works as efficiently as possible.
Help us improve our software quality by reporting any Percona Monitoring and Management bugs you encounter using our bug tracking system.
