Percona监控工具初探

末蓝、 2024-02-18 17:22 14阅读 0赞

Percona在2016年4月发布了一个监控套件，可以同时对多个MySQL、MongoDB实例进行监控

参考资料：  
1. [https://www.percona.com/blog/2016/04/18/percona-monitoring-and-management/][https_www.percona.com_blog_2016_04_18_percona-monitoring-and-management]  
2. [https://www.percona.com/doc/percona-monitoring-and-management/index.html][https_www.percona.com_doc_percona-monitoring-and-management_index.html]  
3. [https://www.percona.com/doc/percona-monitoring-and-management/install.html][https_www.percona.com_doc_percona-monitoring-and-management_install.html]  
安装过程描述的非常详尽，参考此文档足以

#### 环境 ####

操作系统版本CentOS 6.7  
MySQL版本为 MySQL 5.7

#### 1. 安装 ####

![这里写图片描述][20161123131702430]

##### 1.1 PMM Server #####

负责将收集到的数据存储、聚合和展现  
假定安装在192.168.100.1上  
1)

docker percona/pmm-server:1.0.6
     
     
      
       1

2）

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.0.6 /bin/true
     
     
      
       1 
       2 
       3 
       4 
       5 
       6 
       7

3）

$ docker run -d \
       -p 80:80 \
       --volumes-from pmm-data \
       --name pmm-server \
       --restart always \
       percona/pmm-server:1.0.6
     
     
      
       1 
       2 
       3 
       4 
       5 
       6

到此，docker已经启动，可以访问

<table style="border-collapse:collapse; border-spacing:0px; max-width:100%; width:860px; border:1px solid rgb(238,238,238); color:rgb(63,63,63); font-family:&quot;microsoft yahei&quot;; font-size:16px"> 
 <thead style=""> 
  <tr style=""> 
   <th align="left" style="text-align:left; padding:8px; line-height:20px; vertical-align:top; border:1px solid rgb(238,238,238)"> Component</th> 
   <th align="left" style="text-align:left; padding:8px; line-height:20px; vertical-align:top; border:1px solid rgb(238,238,238)"> URL</th> 
   <th align="left" style="text-align:left; padding:8px; line-height:20px; vertical-align:top; border:1px solid rgb(238,238,238)"> 备注</th> 
  </tr> 
 </thead> 
 <tbody style=""> 
  <tr style=""> 
   <td align="left" style="padding:8px; line-height:20px; vertical-align:top; border:1px solid rgb(238,238,238)"> PMM landing page</td> 
   <td align="left" style="padding:8px; line-height:20px; vertical-align:top; border:1px solid rgb(238,238,238)"> <a href="http://192.168.100.1/" style="background:transparent; color:rgb(202,12,22); margin:0px; padding:0px; outline:0px" rel="nofollow">http://192.168.100.1</a></td> 
   <td align="left" style="padding:8px; line-height:20px; vertical-align:top; border:1px solid rgb(238,238,238)"> 跳转页</td> 
  </tr> 
  <tr style=""> 
   <td align="left" style="padding:8px; line-height:20px; vertical-align:top; border:1px solid rgb(238,238,238)"> Query Analytics (QAN web app)</td> 
   <td align="left" style="padding:8px; line-height:20px; vertical-align:top; border:1px solid rgb(238,238,238)"> <a href="http://192.168.100.1/qan/" style="background:transparent; color:rgb(202,12,22); margin:0px; padding:0px; outline:0px" rel="nofollow">http://192.168.100.1/qan/</a></td> 
   <td align="left" style="padding:8px; line-height:20px; vertical-align:top; border:1px solid rgb(238,238,238)"> SQL分析</td> 
  </tr> 
  <tr style=""> 
   <td align="left" style="padding:8px; line-height:20px; vertical-align:top; border:1px solid rgb(238,238,238)"> Metrics Monitor (Grafana)</td> 
   <td align="left" style="padding:8px; line-height:20px; vertical-align:top; border:1px solid rgb(238,238,238)"> <a href="http://192.168.100.1/graph/" style="background:transparent; color:rgb(202,12,22); margin:0px; padding:0px; outline:0px" rel="nofollow">http://192.168.100.1/graph/</a>&nbsp;<br style=""> user name: admin password: admin</td> 
   <td align="left" style="padding:8px; line-height:20px; vertical-align:top; border:1px solid rgb(238,238,238)"> 监控指标图表</td> 
  </tr> 
  <tr style=""> 
   <td align="left" style="padding:8px; line-height:20px; vertical-align:top; border:1px solid rgb(238,238,238)"> Orchestrator</td> 
   <td align="left" style="padding:8px; line-height:20px; vertical-align:top; border:1px solid rgb(238,238,238)"> <a href="http://192.168.100.1/orchestrator" style="background:transparent; color:rgb(202,12,22); margin:0px; padding:0px; outline:0px" rel="nofollow">http://192.168.100.1/orchestrator</a></td> 
   <td align="left" style="padding:8px; line-height:20px; vertical-align:top; border:1px solid rgb(238,238,238)"> MySQL集群拓扑结构</td> 
  </tr> 
 </tbody> 
</table>

其它：  
进入docker能够发现

UID        PID  PPID  C STIME TTY          TIME CMD
    root         1     0  0 Nov22 ?        00:00:00 /bin/bash /opt/entrypoint.sh
    root        13     1  0 Nov22 ?        00:00:28 /usr/bin/python /usr/bin/supervisord -c /etc/supervisor/supervisor
    mysql       16    13  0 Nov22 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe
    pmm         17    13  0 Nov22 ?        00:05:23 /opt/consul agent -server -data-dir=/opt/consul-data -bootstrap -c
    grafana     18    13  0 Nov22 ?        00:01:28 /usr/sbin/grafana-server --homepath=/usr/share/grafana --config=/e
    root        19    13  0 Nov22 ?        00:00:00 nginx: master process nginx
    root        20    13  0 Nov22 ?        00:00:00 /usr/sbin/cron -f
    pmm         24    13  0 Nov22 ?        00:00:00 bash -c sleep 5 && /usr/local/percona/qan-api/start
    pmm         28    13 10 Nov22 ?        02:11:57 /opt/prometheus/prometheus -config.file=/opt/prometheus/prometheus
    pmm         40    13  0 Nov22 ?        00:00:00 bash -c sleep 7 && /usr/local/orchestrator/orchestrator http
    root        50    13  2 Nov22 ?        00:36:27 /opt/node_exporter/node_exporter -web.listen-address=localhost:910
    www-data   105    19  0 Nov22 ?        00:00:04 nginx: worker process
    www-data   106    19  0 Nov22 ?        00:00:04 nginx: worker process
    www-data   107    19  0 Nov22 ?        00:00:05 nginx: worker process
    www-data   108    19  0 Nov22 ?        00:00:03 nginx: worker process
    mysql      427    16  0 Nov22 ?        00:06:55 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-
    pmm        458    24  0 Nov22 ?        00:00:00 bash /usr/local/percona/qan-api/start
    pmm        471   458  0 Nov22 ?        00:03:10 /usr/local/percona/qan-api/bin/percona-qan-api -importPath github.
    pmm        480   471  0 Nov22 ?        00:00:00 perl /usr/local/percona/qan-api/src/github.com/percona/qan-api/ser
    pmm        499    40  0 Nov22 ?        00:03:44 /usr/local/orchestrator/orchestrator http
     
     
      
       1 
       2 
       3 
       4 
       5 
       6 
       7 
       8 
       9 
       10 
       11 
       12 
       13 
       14 
       15 
       16 
       17 
       18 
       19 
       20 
       21

依照我的推断，从client端收集到的监控数据存储在MysQL中，然后经过聚合以后，在grafana中进行展现，因此为防止收集到监控数据丢失，可以在docker启动时，用-v参数把/var/lib/mysql，/var/lib/grafana 两个目录挂到宿主机上

##### 1.2 PMM Client #####

负责收集MySQL的状态数据，并发给PMM Server  
假定安装在192.168.200.1上  
1） 安装percona仓库

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

2）安装client包

sudo yum install pmm-client
     
     
      
       1

3）配置监控

sudo pmm-admin add mysql --user root --password xxxx --host 127.0.0.1 --port 3306
     
     
      
       1

看到这里大家可能会想可以按host和port进行配置，pmm-client 是否无须部署到MySQL对应的机器上，其实这种说法是对的

pmm-client收的监控数据来源有这么几块  
a. MySQL所在机器的系统指标  
b. MySQL的performance\_schema库  
c. slow-log(慢查询日志)

所以如果我们想收集a和c中的指标的话，最好还是将pmm-client部署在MySQL所在机器

4）查看配置后的结果

sudo pmm-admin list
     
     
      
       1

pmm-admin 1.0.6
    
    PMM Server      | 192.168.100.1:80
    Client Name     | wx-test-social18
    Client Address  | 192.168.200.1
    Service manager | unix-systemv
    
    ---------------- ----------------- ------------ -------- ----------------------------- ------------------------
    SERVICE TYPE     NAME              CLIENT PORT  RUNNING  DATA SOURCE                   OPTIONS
    ---------------- ----------------- ------------ -------- ----------------------------- ------------------------
    linux:metrics    wx-test-social18  42000        YES      -
    mysql:queries    wx-test-social18  42001        YES      root:***@tcp(127.0.0.1:3306)  query_source=perfschema
    mysql:metrics    wx-test-social18  42002        YES      root:***@tcp(127.0.0.1:3306)
     
     
      
       1 
       2 
       3 
       4 
       5 
       6 
       7 
       8 
       9 
       10 
       11 
       12 
       13

#### 2. 交互界面 ####

##### 2.1 访问[http://192.168.100.1/qan/][http_192.168.100.1_qan] #####

可以查看Query的分析结果  
![这里写图片描述][20161123132001181]

##### 2.2 访问[http://192.168.100.1/graph/][http_192.168.100.1_graph] #####

部分系统指标  
![这里写图片描述][20161123132658935]  
MySQL的指标数据  
![这里写图片描述][20161123132347650]  
单表的统计情况  
![这里写图片描述][20161123132516589]

[https_www.percona.com_blog_2016_04_18_percona-monitoring-and-management]: https://www.percona.com/blog/2016/04/18/percona-monitoring-and-management/
[https_www.percona.com_doc_percona-monitoring-and-management_index.html]: https://www.percona.com/doc/percona-monitoring-and-management/index.html
[https_www.percona.com_doc_percona-monitoring-and-management_install.html]: https://www.percona.com/doc/percona-monitoring-and-management/install.html
[20161123131702430]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/c91972ce3217409bbbadbd1e8a93d4fe.png
[http_192.168.100.1_qan]: http://192.168.100.1/qan/
[20161123132001181]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/a35fe34296e54f37bf92b255da1a1118.png
[http_192.168.100.1_graph]: http://192.168.100.1/graph/
[20161123132658935]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/94776ecf89894ab2b34907b528107750.png
[20161123132347650]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/24f6e862fee84db3ad0aca5c641ec0b0.png
[20161123132516589]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/e6ff57cd1cef490984bc5c871af89923.png