运维监控之使用Prometheus + Grafana 监控 mysql

lyb-geek

发布于 2019-07-17 11:28:10

1.6K0

发布于 2019-07-17 11:28:10

文章被收录于专栏：Linyb极客之路Linyb极客之路

一、前言

上篇我们介绍如何通过Prometheus + Grafana +node explorer来监控linux，本文介绍一下如何通过Prometheus + Grafana +mysqld explorer来监控mysql

二、安装mysqld explorer

1、下载mysqld explorer安装包并解压

wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.11.0/mysqld_exporter-0.11.0.linux-amd64.tar.gz
tar -zvxf mysqld_exporter-0.11.0.linux-amd64.tar.gz
mv mysqld_exporter-0.11.0.linux-amd64 mysqld

2、在想监控的数据库中，创建mysqld explorer专有用户

mysql> create user 'mysqldExporter'@'localhost' identified by 'mysqldExporter';
Query OK, 0 rows affected (0.00 sec)

mysql> grant REPLICATION CLIENT,PROCESS ON *.* TO 'mysqldExporter'@'localhost';
Query OK, 0 rows affected (0.00 sec)

mysql> grant SELECT ON *.* TO 'mysqldExporter'@'localhost';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

3、创建mysqld exporter配置文件.my.cnf

cd /home/mysqld
vim .my.cnf
填入如下内容
[client]
user=mysqldExporter
password=mysqldExporter

4、运行mysqld explorer

service mysqldExporter start
注：mysqldExporter为服务脚本名称，具体脚本查看附录链接，本例中mysqld explorer端口为9104

三、mysqld explorer和prometheus整合

1、修改prometheus.yml配置文件

cd /home/prometheus
vim prometheus.yml
添加如下内容，targets里面配置为mysqld explorer的访问地址

  - job_name: 'mysql'
    static_configs:
    - targets: ['localhost:9104']