centos7 Percona Monitoring and Management

oToyix

已于 2022-04-08 17:05:19 修改

阅读量1.6k

点赞数 1

分类专栏： linux常用基础技能及服务 # mysql_mariadb_mongodb 监控_Zabbix_prometheus 文章标签： pmm Percona Monitoring Management

于 2022-04-08 15:49:40 首次发布

本文链接：https://blog.csdn.net/oToyix/article/details/124043211

版权

linux常用基础技能及服务同时被 3 个专栏收录

76 篇文章 1 订阅

订阅专栏

mysql_mariadb_mongodb

33 篇文章 0 订阅

订阅专栏

监控_Zabbix_prometheus

15 篇文章 0 订阅

订阅专栏

服务端

下载PMM Server Docker镜像

docker pull percona/pmm-server:1.1.1

# 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.1 /bin/true

（2）启动

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

客户端

wget -c https://www.percona.com/downloads/pmm-client/pmm-client-1.1.1/binary/tarball/pmm-client-1.1.1.tar.gz
tar -xf pmm-client-1.1.1.tar.gz
cd pmm-client-1.1.1/
./install

连接PMM Server
pmm-admin config --server 192.168.0.60:808

OK, PMM server is alive.

PMM Server      | 192.168.0.60:808 
Client Name     | localhost.localdomain
Client Address  | 192.168.0.60

增加MySQL监控服务

pmm-admin add mysql --user admin --password 123456--host 192.168.0.60           
[linux:metrics] OK, now monitoring this system.
[mysql:metrics] OK, now monitoring MySQL metrics using DSN admin:***@tcp(192.168.0.60:3306)
[mysql:queries] OK, now monitoring MySQL queries from perfschema using DSN admin:***@tcp(192.168.0.60:3306)

查看
pmm-admin list

 pmm-admin list
pmm-admin 1.1.1

PMM Server      | 192.168.0.60:808 
Client Name     | localhost.localdomain
Client Address  | 192.168.0.60 
Service Manager | linux-systemd


-------------- ---------------------- ----------- -------- ----------------------------------- ------------------------
SERVICE TYPE   NAME                   LOCAL PORT  RUNNING  DATA SOURCE                         OPTIONS                 
-------------- ---------------------- ----------- -------- ----------------------------------- ------------------------
mysql:queries  localhost.localdomain  -           YES      admin:***@tcp(192.168.0.60:3306)  query_source=perfschema 
linux:metrics  localhost.localdomain  42000       YES      -                                                           
mysql:metrics  localhost.localdomain  42002       YES      admin:***@tcp(192.168.0.60:3306)