Percona Monitoring and Management (PMM)是一款監(jiān)控和管理Mysql和Mongodb的開源工具
包括 PMM-Client和PMM-Server
操作系統(tǒng)：CentOS 7
PMM-Client: 192.168.200.1
PMM-Server: 192.168.100.1
安裝PMM-Client
- 配置yum源并安裝
yum install http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm
yum install pmm-client
安裝PMM-Server
采用docker方式安裝PMM-Server
docker安裝過程參考http://www.itdecent.cn/p/d9e1fa0997ca
- 下載鏡像
docker pull percona/pmm-server:latest
- 創(chuàng)建pmm-data容器
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
- 創(chuàng)建和運(yùn)行PMM-Server容器
docker run -d \
-p 80:80 \
--volumes-from pmm-data \
--name pmm-server \
--restart always \
percona/pmm-server:latest
- 連接PMM-Client和PMM-Server
pmm-admin config --server 192.168.100.1
- 收集數(shù)據(jù)
如果在my.cnf文件中有如下配置
[client]
password=123456
直接運(yùn)行
pmm-admin add mysql
如果沒有配置密碼，在后面加上合適的參數(shù)
Use additional flags --user, --password, --host, --port, --socket if needed.
- 查看添加效果
[root@localhost ~]# pmm-admin list
pmm-admin 1.9.0
PMM Server | 192.168.100.1
Client Name | localhost.localdomain
Client Address | 192.168.200.1
Service Manager | linux-upstart
-------------- ---------------------- ----------- -------- ----------------------------------------- ------------------------------------------
SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS
-------------- ---------------------- ----------- -------- ----------------------------------------- ------------------------------------------
mysql:queries localhost.localdomain - YES root:***@unix(/var/lib/mysql/mysql.sock) query_source=slowlog, query_examples=true
linux:metrics localhost.localdomain 42000 YES -
mysql:metrics localhost.localdomain 42002 YES root:***@unix(/var/lib/mysql/mysql.sock)
網(wǎng)頁登陸：192.168.100.1
