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