服务端创建存储卷并运行pmm容器

[root@localhost ~]# docker create -v /opt/prometheus/data -v /opt/consul/data -v /var/lib/mysql -v /var/lib/grafana --name pmm-data percona/pmm-server:latest 
[root@localhost ~]# docker run -d -p 80:80 --volumes-from pmm-data --name pmm-server --restart always -e SERVER_USER=test -e SERVER_PASSWORD=123456 percona/pmm-server:latest

访问服务端PMM web界面：http://服务端ip 账户名为test 密码为123456

客户端连接服务端

pmm-admin config --server 服务端ip:80 --server-user test --server-password 123456

客户端添加系统监控

[root@localhost ~]# pmm-admin add linux:metrics
OK, now monitoring this system.

客户端修改mysql配置

[root@localhost ~]# vim /etc/my.cnf
尾部添加
log_output=file 
slow_query_log=ON  
long_query_time=0
log_slow_rate_limit=100
log_slow_rate_type=query
log_slow_verbosity=full
log_slow_admin_statements=ON
log_slow_slave_statements=ON
slow_query_log_always_write_time=1
slow_query_log_use_global_control=all
innodb_monitor_enable=all
userstat=1

[root@localhost ~]# systemctl restart mysqld

客户单授权监控用户

[root@localhost ~]# mysql -uroot -p123456

mysql> grant all on *.* to 'pmm'@'客户端ip' identified by '12345678';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

客户端添加对mysql的监控项

pmm-admin add mysql:metrics --user pmm --password 12345678 --host 192.168.43.253 --port 3306

pmm-admin add mysql --query-source auto --user pmm --password 12345678 --host 192.168.43.253 --port 3306

效果

监控图表查看