Percona Monitoring and Management

Percona Monitoring and Management (PMM) is an open source database observability, monitoring, and management platform that gives you a single view of performance metrics - from entire database clusters down to individual queries.

Key features:

• Complete visibility of MySQL, PostgreSQL, and MongoDB performance
• Unified dashboard for all your database metrics and query analytics
• Flexible deployment options: on-premises, cloud, or hybrid environments
• Easy setup with just two components: Server and Client

Software Included

Creating an App using the Control Panel

Click the Deploy to DigitalOcean button to create a Droplet based on this 1-Click App. If you aren’t logged in, this link will prompt you to log in with your DigitalOcean account.

Creating an App using the API

In addition to creating a Droplet from the Percona Monitoring and Management 1-Click App using the control panel, you can also use the DigitalOcean API. As an example, to create a 4GB Percona Monitoring and Management Droplet in the SFO2 region, you can use the following curl command. You need to either save your API access token) to an environment variable or substitute it in the command below.

curl -X POST -H 'Content-Type: application/json' \
         -H 'Authorization: Bearer '$TOKEN'' -d \
        '{"name":"choose_a_name","region":"sfo2","size":"s-2vcpu-4gb","image": "sharklabs-perconamonitorin"}' \
        "https://api.digitalocean.com/v2/droplets"

Getting Started After Deploying Percona Monitoring and Management

Log in to the PMM web interface at https://your_droplet_public_ipv4/ with the username admin and the password admin. You will be prompted to set a different password.

Start monitoring remote MySQL, PostgreSQL or MongoDB instances by navigating to the PMM Add Instance dashboard using the PMM button near the top right of the Home dashboard.

Optionally, you can log in to your PMM droplet with SSH using:

ssh admin@your_droplet_public_ipv4

You can allow additional SSH public keys to authenticate to your PMM Droplet from the PMM Settings dashboard within PMM.

The easiest way to add your DigitalOcean MySQL database clusters to PMM is to run the helper script:

python3 /root/pmm-do.py

The script will walk you through monitoring some or all of your MySQL instances with Percona Monitoring and Management.