Install Percona Monitoring and Management
Step 1: Install PMM Server
Applies to: All Docker compatible *nix based systems
Requirements: Docker
We have developed an easy installation script that will check and install, if necessary, any missing software. Run the command as a user with sudo privileges or as root.
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.
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.
Step 2: Install PMM Client
Choose either Ubuntu or Red Hat:
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
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
Step 3: Connect Client to Server
Applies to: All (optional if only using AWS Monitoring)
Requirements: Client to server communication to secure port on pmm-server (443 assumed) — must be performed on every system to be monitored.
Register Percona Monitoring and Management client with server
sudo pmm-admin config --server-insecure-tls --server-url=https://admin:<password>@pmm.example.com
Step 4: Create a PMM user for monitoring
Applies to: All
MySQL 8.0
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, BACKUP_ADMIN ON *.* TO 'pmm'@'localhost';
Register the server for monitoring
sudo pmm-admin add mysql --username=pmm --password=<password> --query-source=perfschema
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
For more advanced installation and configuration options, please see the full download and documentation pages, or visit our Percona Monitoring and Management Forum for additional assistance.
Step 5: Connect PMM to your Percona Account
Note: This step is recommended and not mandatory.
Don’t have a Percona Account yet?
Percona Account is a single login provides you with seamless access across all of your Percona properties, as well as insights for your database environment, knowledge base, unified view of support tickets with Percona and ServiceNow, and guidance from Percona experts.
Need help with your open source setup?
By submitting my information I agree that Percona may use my personal data in sending communication to me about Percona services. I understand that I can unsubscribe from the communication at any time in accordance with the Percona Privacy Policy.This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.