percona installation

INSTALL ON SERVER SIDE

OS ON CENTOS

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

INSTALL ON AGENT SIDE

CREATE USER DB MYSQL

CREATE USER 'pmm'@'127.0.0.1' IDENTIFIED BY '<your_password>' WITH MAX_USER_CONNECTIONS 10;
GRANT SELECT, PROCESS, REPLICATION CLIENT, RELOAD, BACKUP_ADMIN ON *.* TO 'pmm'@'127.0.0.1';

INSTALL PERCONA-AGENT

wget https://repo.percona.com/apt/percona-release_latest.generic_all.deb
sudo dpkg -i percona-release_latest.generic_all.deb
apt update
apt install -y pmm2-client
pmm-admin config --server-insecure-tls --server-url=https://admin:[email protected]:443
pmm-admin add mysql --query-source=perfschema --username=pmm --password=<your_password>

INSTALL XTRABACKUP

FOR MYSQL 8.0 LINK https://docs.percona.com/percona-xtrabackup/8.0/installation.html?utm_source=pmm&utm_medium=pmm_app&utm_campaign=pmm_app_links
wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb
sudo apt update
sudo apt install percona-xtrabackup-80

FOR MYSQL 2.4-5.7 LINK https://docs.percona.com/percona-xtrabackup/2.4/installation/apt_repo.html
wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb
sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb
sudo apt install percona-xtrabackup-24
sudo apt install qpress \

UNINSTALL

$ sudo apt remove percona-xtrabackup-24/80