mysql exporter怎么配置_prometheus mysqld_exporter监控mysql-5.7

1、下载及解压安装包

https://github.com/prometheus/mysqld_exporter

tar -xvf mysqld_exporter-0.11.0.linux-amd64.tar.gz -C /app/prometheus

2、创建密码填写内容.my.cnf文件

vim .my.cnf

[client]

host=127.0.0.1

user=root

password=root

3、创建mysqld_exporter.service 的 systemd unit 文件

vim /usr/lib/systemd/system/mysqld_exporter.service

[Unit]

Description=node_exporter

Documentation=https://prometheus.io/

After=network.target

[Service]

Type=simple

User=prometheus

ExecStart=/app/prometheus/mysqld_exporter/mysqld_exporter --config.my-cnf=/app/prometheus/mysqld_exporter/.my.cnf

Restart=on-failure

[Install]

WantedBy=multi-user.target

4、启动服务

systemctl daemon-reload

systemctl enable mysqld_exporter.service

systemctl start