部署mysqld_exporter

创建数据库账号：

use mysql;
CREATE USER 'exporter'@'%' IDENTIFIED BY '1qaz@WSX';
grant SELECT,UPDATE,INSERT,DELETE on *.* To 'exporter'@'%';
flush privileges;

下载mysqld_exporter:

tar -xf mysqld_exporter-0.17.2.linux-amd64.tar.gz -C /app/
cd /app/
mv mysqld_exporter-0.17.2.linux-amd64/ mysqld_exporter

编辑my-exporter.cnf:

cat mysqld_exporter.cnf
[client]
user=exporter
password=1qaz@WSX
host=100.100.137.87
port=3306

启动mysqd_exporter:

cat /usr/lib/systemd/system/mysqld_exporter.service
[Unit]
Description=Prometheus
After=network-online.target

[Service]
Restart=on-failure
ExecStart=/app/mysqld_exporter/mysqld_exporter --config.my-cnf=/app/mysqld_exporter/mysqld_exporter.cnf

[Install]
WantedBy=multi-user.target

systemctl daemon-reload 
systemctl enable mysqld_exporter
systemctl start  mysqld_exporter
systemctl status   mysqld_exporter

配置prometheus

  - job_name: "mysqld_exporter"
    scrape_interval: 15s
    scrape_timeout: 5s
    static_configs:
      - targets: ["100.100.137.87:9104"]
        labels:
          group: test
          name: 'test-ruoyi-mysql'
      - targets: ["100.100.137.92:9104"]
        labels:
          group: prod
          name: 'prod-ruoyi-mysql'


systemctl restart prometheus

配置grafana

直接使用 17320 代码导入即可：