Install Percona Monitoring and Management using Docker

You can any distribution for installation- Rocky/Alma/CentoS 8 Stream. I assume you’ll use anyone of these instance.

Step 1: Add Docker Repository

Docker is not yet available on default repositories. Thankfully, an official repository has been provided by developers and we are going to add it first to the system. On your terminal, run the following command to add the Docker repository

$ sudo dnf config-manager --add-repo=https://download.docker.com/linux/centos/docker-ce.repo

Step 2: Install Docker in Rocky Linux/AlmaLinux

Moving on, we are going to install the Docker community edition which is freely available for download and use. But first, update the packages.

$ sudo dnf update

Next, run the command below to install Docker CE, the command-line interface (CLI), and other essential tools and dependencies.

$ sudo dnf install -y docker-ce docker-ce-cli containerd.io

Install Docker in Rocky Linux/Red Hat/CentOS Stream/AlmaLinux

Once installed, confirm the version of Docker that you have installed as provided. The output shows that we have installed Docker 20.10.

$ docker --version
Docker version 20.10.8, build 3967b7d

Step 3: Start and Enable Docker

To begin using Docker, we need to start the Docker daemon. But first, let’s enable it to start on boot as shown.

$ sudo systemctl enable docker

Then start the Docker daemon.

$ sudo systemctl start docker

To confirm the running status of Docker, issue the command.

$ sudo systemctl status docker

Check Docker Status

Perfect! Docker is running as expected.

Step-4: Install PMM Server

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

or you can use wget instead either-

wget -O - https://www.percona.com/get/pmm | /bin/bash

Step-5: Install PMM client on Redhat and Ubuntu based-

RedHat: Install PMM 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

Ubuntu: Install PMM Client

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:6: 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-7: Create a PMM user for monitoring 

For 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

For 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

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

Congratulations! You should now have a successful basic PMM installation. We encourage you to click through the PMM application to ensure your configured database(s) are appearing within the PMM interface and are collecting data as expected.

Src: https://www.tecmint.com/install-docker-in-rocky-linux-and-almalinux/
https://www.percona.com/software/pmm/quickstart

 

Share

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.