1. 准备

Grafana、Prometheus等相关包的安装参考：Grafana+Prometheus监控Linux - 掘金 (juejin.cn)

2. 安装mysqld_exporter

下载地址：prometheus.io/download/ ,放到目录/usr/local。

2.1 解压

tar -xf mysqld_exporter-0.14.0.linux-amd64.tar.gz
mv mysqld_exporter-0.14.0.linux-amd64 mysqld_exporter

2.2 创建mysql_exporter配置文件

vim /usr/local/mysqld_exporter/.my.cnf

输入以下内容：

[client]
user=mysql_monitor
password=123456

2.3 mysql创建监控用户

grant select,replication client, process on *.* to 'mysql_monitor'@'localhost' identified by '123456';
flush privileges;

2.4 以服务方式启动mysql_exporter

vim /etc/systemd/system/mysqld_exporter.service

输入：

[Unit]
Description=mysqld_exporter
After=network.target
 
[Service]
ExecStart=/usr/local/mysqld_exporter/mysqld_exporter \
  --config.my-cnf=/usr/local/mysqld_exporter/.my.cnf
Restart=on-failure
[Install]
WantedBy=multi-user.target

2.5 启动mysql_exporter

systemctl daemon-reload
systemctl enable node_exporter
systemctl start node_exporter
systemctl status node_exporter

3. 配置prometheus

/usr/local/prometheus/prometheus.yml

新增框中内容：

重启prometheus：

systemctl restart prometheus

检查

4. grafana添加模板

参考第一节准备内容

展示：