prometheus 监控MySQL

下载需要的版本

https://github.com/prometheus/mysqld_exporter/releases/tag/v0.13.0

登录mysql 创建给 监控的账户

mysql> GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'%' IDENTIFIED BY 'Test123456!' WITH MAX_USER_CONNECTIONS 3;

Query OK, 0 rows affected, 1 warning (0.10 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> exit

创建监控文件

tar zxvf mysqld_exporter-0.13.0.linux-amd64.tar.gz

mv mysqld_exporter-0.13.0.linux-amd64 /usr/local/mysql_exporter

cd /usr/local/mysql_exporter/

创建一个.my.cnf的文件，文件内容如下

[client]

user=exporter

password=Test123456!

启动监控，默认端口9104

nohup ./mysqld_exporter --config.my-cnf=".my.cnf" &

修改prometheus.yml文件

- job_name: 'db_server'

static_configs:

- targets: ['192.168.1.108:9104']

导入模板 7362