Install Percona Monitoring and Management

curl -fsSL https://www.percona.com/get/pmm | /bin/bash

When the installation finishes, information on how to access the interface will display along with the default credentials.

Ubuntu: Install PMM Client

Requirements: None

1. Download Percona Repo Package

wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb

2. Install Percona Repo Package

sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb

3. Update apt cache

sudo apt-get update

4. Install Percona Monitoring and Management Client

sudo apt-get install pmm2-client

MySQL 5.7

Create a Percona Monitoring and Management specific user for monitoring (using mysql CLI)

CREATE USER 'pmm'@'localhost' IDENTIFIED BY 'pass' WITH MAX_USER_CONNECTIONS 10;
GRANT SELECT, PROCESS, SUPER, REPLICATION CLIENT, RELOAD ON *.* TO 'pmm'@'localhost';

Register the server for monitoring

sudo pmm-admin add mysql --username=pmm --password=<password> --query-source=perfschema

Postgres

Create a Percona Monitoring and Management specific user for Monitoring (using the postgres CLI)

CREATE USER pmm WITH SUPERUSER ENCRYPTED PASSWORD '<password>';

Register the server for monitoring

sudo pmm-admin add postgresql --username='pmm' --password=<password>

MongoDB

Create a Percona Monitoring and Management specific user for monitoring (from the MongoDB CLI)

Enter the MongoDB Console: mongo

use admin

db.createRole({
   "role":"explainRole",
   "privileges":[
      {
         "resource":{
            "db":"",
            "collection":""
         },
         "actions":[
            "collStats",
            "dbHash",
            "dbStats",
            "find",
            "listIndexes",
            "listCollections"
         ]
      }
   ],
   "roles":[]
})

db.getSiblingDB("admin").createUser({
   "user":"pmm",
   "pwd":"<password>",
   "roles":[
      {
         "role":"explainRole",
         "db":"admin"
      },
      {
         "role":"clusterMonitor",
         "db":"admin"
      },
      {
         "role":"read",
         "db":"local"
      }
   ]
})
exit

Register the server for monitoring

sudo pmm-admin add mongodb --username=pmm --password=<password>

AWS RDS

AWS Configuration

• You will need your AWS RDS Access Key and RDS Secret Access Key
• This key should have permission to monitor RDS and it is recommended that you enable “Enhanced Monitoring” for the most robust data
• You will also need a database username and password with access to login to the RDS instance
• Your PMM instance will need access to your RDS instance via a TCP port

Percona Monitoring and Management Configuration

• From Percona Monitoring and Management Home Dashboard choose PMM menu → PMM Add Instance
• Choose ‘Add an AWS RDS MySQL or Aurora MySQL Instance’
• Enter your AWS Access Key and Secret Access Key then click “Discover”
• You will be presented with all instances your access key has access to, simply click ‘Start Monitoring’ next to the desired instance
• On the resulting screen you should not need to change any values, simply enter the credentials for your DB instance
• Optionally, you can fill in labels or toggle any of the Additional Options, or click the ‘Add Service’ button at the bottom