上篇我们介绍如何通过Prometheus + Grafana +node explorer来监控linux,本文介绍一下如何通过Prometheus + Grafana +mysqld explorer来监控mysql
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
1、修改prometheus.yml配置文件
cd /home/prometheus
vim prometheus.yml
添加如下内容,targets里面配置为mysqld explorer的访问地址
- job_name: 'mysql'
static_configs:
- targets: ['localhost:9104']
2、通过浏览器访问prometheus,验证是否集成成功
up说明已经集成成功
因为这个整合和上文介绍的Prometheus + Grafana +node explorer操作方式一样,因此就不花篇幅介绍,就直接显示最终的效果图
https://github.com/lyb-geek/monitor-scrpit