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 Client

yum install http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm

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

检查网络

查看prometheus状态

监控慢查询日志

查看mysql状态

查看prometheus状态

查看节点状态