PMM (Percona MySQL Monitor) 部署

部署环境说明

mysql 10.0.0.201

pmm server 10.0.0.200

操作系统都是centos 7.x


安装PMM

安装docker

yum install docker

运行docker

systemctl start docker

systemctl enable docker


下载容器镜像

docker pull percona/pmm-server:latest

建立数据卷容器

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
运行PMM Server

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

访问PMM Server

PMM (Percona MySQL Monitor) 部署


安装PMM Client

yum list | grep percona
yum install pmm-client

配置PMM Client连接PMM Server

pmm-admin config --server 10.0.0.200

采集数据

pmm-admin add mysql --query-source perfschema --user root --password password
检查网络
PMM (Percona MySQL Monitor) 部署

查看prometheus状态
PMM (Percona MySQL Monitor) 部署

监控慢查询日志
PMM (Percona MySQL Monitor) 部署

查看mysql状态
PMM (Percona MySQL Monitor) 部署

查看prometheus状态
PMM (Percona MySQL Monitor) 部署

查看节点状态
PMM (Percona MySQL Monitor) 部署