Requirements: None

1. Download and install Percona Repo Package

sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm

2. Install Percona Monitoring and Management Client

sudo yum install pmm2-client

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

Grant all privileges on *.* to 'pmm'@'localhost' identified by '<password>' with grant option;

Flush privileges;

Register the server for monitoring

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

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> <friendlyName>

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: [
"listIndexes",
"listCollections",
"dbStats",
"dbHash",
"collStats",
"find"
]
}],
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> <friendlyName>

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