环境说明
系统:centos 7,
docker :Docker version 17.03.1-ce, build c6d412e,
percona monitoring and management:1.1.3
步骤
docker安装
需要禁用selinux,否则使用docker会出现一些权限问题docker的版本需要大于1.13创建PMM docker容器
-v参数指定数据存放的数据卷,用来确保所有的PMM数据,不要删除或重新创建容器,除非打算清除所有的PMM数据docker create \ -v /opt/prometheus/data \ -v /opt/consul-data \ -v /var/lib/mysql \ -v /var/lib/grafana \ --name pmm-data \ percona/pmm-server:1.1.3 /bin/true
运行PMM服务容器
此处开启登录认证(用户名:admin,密码:admin)docker run -d -p 80:80 \ -v /opt/prometheus/data \ -v /opt/consul-data \ -v /var/lib/mysql \ -v /var/lib/grafana \ -e SERVER_USER=admin \ -e SERVER_PASSWORD=admin \ --name pmm-server \ --restart always \ percona/pmm-server:1.1.3
备注:如果启动不加SERVER_USER和SERVER_PASSWORD可以进入容器/bin/bash来手动启动认证在/etc/grafana/grafana.ini
打开地址访问验证
Component URL PMM landing page http://192.168.119.135 Query Analytics (QAN web app) http://192.168.119.135/qan/ Metrics Monitor (Grafana) http://192.168.119.135/graph/User name: admin Password: admin Orchestrator http://192.168.119.135/orchestrator
![]()
安装PMM客户端
需要在服务器上安装percona yum源
yum install https://www.percona.com/redir/downloads/percona-release/redhat/latest/percona-release-0.1-4.noarch.rpm
安装pmm-client
yum install pmm-client -y
将PMM客户端连接到PMM服务器
配置连接到服务器添加监听的mysqlpmm-admin config --server 192.168.119.135 --server-user admin --server-password admin
添加mysql 监控最好开启mysql的慢查询日志pmm-admin add mysql --user root --password root --host 127.0.0.1 --port 3306
添加mongodb监控此处mongodb的host=localhost ,port=27017pmm-admin add mongodb
PMM服务问题解决
问题1:QAN API error: "qh.Profile: No query classes for selected instance and time range. Please check whether your MySQL settings match the recommended.".这是由于没有慢查询日志数据导致,只要有数据上来即可
Check the /var/log/qan-api.log file in docker container for more information