PMM监控安装

pmm-server

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 /bin/true

docker run -d \
-p 80:80 \
--volumes-from pmm-data \
--name pmm-server \
--restart always \
percona/pmm-server:latest

pmm-client

#连接pmm-server
[root@db01 /usr/local/percona/pmm2/bin]# docker exec -it 4b55c25b6758 /bin/bash
[root@4b55c25b6758 opt]# pmm-admin config --server-insecure-tls --server-url=https://admin:2020PMM@192.168.56.41:443
Checking local pmm-agent status...
pmm-agent is running.
Registering pmm-agent on PMM Server...
Failed to register pmm-agent on PMM Server: Post " https://192.168.56.41:443/v1/management/Node/Register": dial tcp 192.168.56.41:443: connect: connection refused.
[root@4b55c25b6758 opt]# pmm-admin config --server-insecure-tls --server-url=https://admin:2020PMM@127.0.0.1:443
Checking local pmm-agent status...
pmm-agent is running.
Registering pmm-agent on PMM Server...
Registered.
Configuration file /usr/local/percona/pmm2/config/pmm-agent.yaml updated.
Reloading pmm-agent configuration...
Configuration reloaded.
Checking local pmm-agent status...
pmm-agent is running.

#创建用户并授权
(root@localhost) [mysql]> create user 'root'@'%';
Query OK, 0 rows affected (0.12 sec)
(root@localhost) [mysql]> grant all on *.* to 'root'@'%';
Query OK, 0 rows affected (0.00 sec)

#添加mysql，有密码
pmm-admin add mysql --query-source=perfschema --username=root --password=lhr --host=192.168.66.35 --port=3317 --service-name=mysql-192.168.66.35-3317
#添加mysql，无密码
pmm-admin add mysql --query-source=perfschema --username=root --host=192.168.56.41 --port=3306 --service-name=mysql-192.168.56.41-3306