-->
  • Recent Articles

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

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

    PMM Architecture
    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

               

    Create Volume PMM2
    Devopszones: Create volume


    PMM Server install RHEL8
    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.

    PMM Login Page
    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

    PMM2 Client Install
    Devopszones: PMM2 client Install

    PMM2 client Admin Version
    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>

    PMM2  client Register
    Devopszones: PMM2  client Register


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


    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

    No comments