Percona Monitoring and Management
Pre-Requisites
Pre-Requisites
Install
Install
curl -fsSL https://www.percona.com/get/pmm | /bin/bash
Gathering/downloading required components, this may take a moment
Checking docker installation - installed.
Starting PMM server...Created PMM Data Volume: pmm-dataCreated PMM Server: pmm-server Use the following command if you ever need to update your container by hand: docker run -d -p 443:443 --volumes-from pmm-data --name pmm-server --restart always percona/pmm-server:2
PMM Server has been successfully setup on this system!
You can access your new server using one of the following web addresses: https://172.17.0.1:443/ https://192.168.1.100:443/ https://127.0.0.1:443/
The default username is 'admin' and the password is 'admin' :)Note: Some browsers may not trust the default SSL certificate when you first open one of the urls above.If this is the case, Chrome users may want to type 'thisisunsafe' to bypass the warning.
Enjoy Percona Monitoring and Management!
Checking docker installation - installed.
Starting PMM server...Created PMM Data Volume: pmm-dataCreated PMM Server: pmm-server Use the following command if you ever need to update your container by hand: docker run -d -p 443:443 --volumes-from pmm-data --name pmm-server --restart always percona/pmm-server:2
PMM Server has been successfully setup on this system!
You can access your new server using one of the following web addresses: https://172.17.0.1:443/ https://192.168.1.100:443/ https://127.0.0.1:443/
The default username is 'admin' and the password is 'admin' :)Note: Some browsers may not trust the default SSL certificate when you first open one of the urls above.If this is the case, Chrome users may want to type 'thisisunsafe' to bypass the warning.
Enjoy Percona Monitoring and Management!
Target Configuration
Target Configuration
CREATE USER 'pmm'@'localhost'
IDENTIFIED BY RANDOM PASSWORD
WITH MAX_USER_CONNECTIONS 10;
GRANT SELECT, PROCESS, SUPER, REPLICATION CLIENT, RELOAD, BACKUP_ADMIN
ON *.*
TO 'pmm'@'localhost';
Docker Note: If your target is a Docker container using the offical MySQL image which, by default, will be started in skip-name-resolve mode, then remember to replace 'localhost' with '127.0.0.1' in these commands.'pmm'@'127.0.0.1'
sudo pmm-admin add mysql --username=pmm --password=pass --query-source=perfschema
Processes
Processes
Whilst the PM&M Docker container is running, you are likely to see the following processes appear in your process list (e.g. in conky, top, or ps output)...
victoriametrics
grafana-server
postgres
clickhouse-serv
altinity-clickhouse-plugin_linux_amd64
Bibliography
Bibliography
https://www.percona.com/software/database-tools/percona-monitoring-and-managementhttps://hub.docker.com/r/percona/pmm-serverhttps://www.percona.com/software/pmm/quickstart
(1) Percona Monitoring and Management (PMM) for NovicesDavid Stokes, Percona Technical EvangelistJul 26 2022https://www.brighttalk.com/webcast/18708/550989
https://docs.percona.com/percona-monitoring-and-management/details/commands/pmm-admin.html
https://docs.victoriametrics.com/CaseStudies.html#percona