How to Setup PMM(Percona Monitoring and Management) server and Register PMM client on RHEL based system for AWS RDS

  In this article we will see how to configure PMM (Percona Monitoring and Management) server and PMM Client setup for AWS RDS.

PMM Architecture
Source: https://www.percona.com/

Prerequisites:

1. We need to have Docker 1.12.6 or higher installed.

PMM Server Installation:

1. Pull the image.

   docker pull percona/pmm-server:2
   

2. Create a persistent data container.

   docker create --volume /srv \
   --name pmm-data \
   percona/pmm-server:2 /bin/true

3. Run the image.

   docker run --detach --restart always \
   --publish 443:443 \
   --volumes-from pmm-data \
   --name pmm-server \
   percona/pmm-server:2

           

Devopszones: Create volume

devopszones: PMM server Install

              3. Connect to Percona Monitoring and Management:

https://<IP Address or hostname of your Percona Monitoring and Management Server>/

Default username/password is admin/admin and should be changed on first login.

Devopszones: PMM Login Page

Install Client

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

Devopszones: PMM2 client Install

Devopszones: PMM2 Admin Version

Connect Client to Server

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 Server IP>

Devopszones: PMM2  client Register

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

Easy-install script

Linux

curl -fsSL -O https://raw.githubusercontent.com/percona/pmm/PMM-2.0/get-pmm.sh -O https://raw.githubusercontent.com/percona/pmm/PMM-2.0/.sha256-oneline && \
sha256sum .sha256-oneline -c && \
chmod +x ./get-pmm.sh && \
./get-pmm.sh

How to Backup and Restore PMM(Percona Monitoring and Management) server Data

How to remove PMM Server