How to Monitor Managed MySQL with PMM 1-Click App

Last verified 30 Jul 2026

MySQL is an open source, object-relational database built with speed and reliability in mind. Its large and active developer community has created many third-party applications, tools, and libraries that expand MySQL’s functionality.

Percona Monitoring and Management (PMM) is an open source database observability tool. You can run PMM on a DigitalOcean Droplet using the PMM Marketplace 1-Click App, then connect your managed database clusters so PMM can collect metrics and query analytics.

Deploy the 1-Click App, then install the PMM Integration helper on the Droplet and use its web UI to register DigitalOcean Managed MySQL clusters. For PMM features and setup outside this helper flow, see the PMM documentation.

Warning

Third-party tools can change. Confirm compatibility with your database version and PMM release before production use.

The helper supports Managed MySQL Standard Edition clusters. It does not support MySQL Advanced Edition.

Prerequisites

  • A DigitalOcean account with at least one Managed MySQL Standard Edition cluster.
  • A personal access token with the scopes database:read, database:create, and database:view_credentials. Creating the pmm_monitor user requires database:create and database:view_credentials.

Deploy the PMM 1-Click App

  1. Create a Percona Monitoring and Management Droplet or follow the Control Panel and API steps on the PMM catalog page.
  2. Open the PMM web interface at https://your_droplet_public_ipv4/ and sign in with the default credentials (admin / admin). Change the admin password when prompted.
  3. Copy the Droplet public IPv4 address. You use it to add the Droplet to the cluster’s trusted sources in the next section.

Add the PMM Droplet to Trusted Sources

PMM connects to each managed database over the public network by default. Before you register clusters, add the PMM Droplet as a trusted source on every cluster you plan to monitor.

If the Droplet IP is missing from trusted sources, the helper cannot reach the database and registration fails.

Install the PMM Integration Helper

SSH into the PMM Droplet as root using the SSH key you selected when you created the Droplet:

ssh root@your_droplet_public_ipv4

Install the helper. You do not need sudo because the session is already root:

curl -sSL https://raw.githubusercontent.com/pagombin-do/pmm-integration/main/install.sh | sh

The installer clones the app into /opt/pmm-integration, creates a Python virtual environment, generates a self-signed TLS certificate, opens TCP port 8443 in ufw when ufw is active, and starts the pmm-integration systemd service. The installer is idempotent, so you can re-run it to update the helper.

If you use a DigitalOcean Cloud Firewall on the Droplet, add an inbound rule for TCP port 8443. The installer does not create Cloud Firewall rules.

Register Clusters in the Helper UI

Open the helper in your browser:

https://your_droplet_public_ipv4:8443/

Your browser shows a certificate warning because the TLS certificate is self-signed. Accept the warning to continue.

Complete the following steps in the UI:

  1. Enter your DigitalOcean API token and PMM admin password. The helper validates both before continuing. Credentials stay in browser memory for the session and are never written to disk on the Droplet.
  2. Select the MySQL engine. Optionally enable the private (VPC) endpoint if the Droplet and database are in the same VPC.
  3. Select one or more online Managed MySQL clusters. Clusters that are not online are unavailable. Clusters already registered with PMM show a Remove option.
  4. Create a pmm_monitor database user automatically through the DigitalOcean API, or enter existing monitoring-user credentials manually. If pmm_monitor already exists or you skip auto-create, create or retrieve the credentials in the Control Panel or API, then return to the helper, or add the instance manually in the PMM UI.
  5. Confirm integration. The helper registers each selected cluster with PMM.

MySQL Host Metrics

Managed MySQL does not allow installing host agents such as node_exporter, so PMM Node Summary metrics (CPU, RAM, and disk) stay empty. Database metrics and query analytics are still collected.

Verify Monitoring

In the PMM UI, confirm that the selected services appear and begin reporting metrics. For PMM dashboards and query analytics workflows, see the PMM documentation.

We can't find any results for your search.

Try using different keywords or simplifying your search terms.