1、下载安装包：

https://objects.githubusercontent.com/github-production-release-asset-2e65be/32075541/32c409af-b7bf-4f96-a811-72cf640f4ee4?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20221111%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20221111T014120Z&X-Amz-Expires=300&X-Amz-Signature=9938279f5358531e4d89330be1092dd518bdd2a80a89197b65b6e81a48ed6f75&X-Amz-SignedHeaders=host&actor_id=0&key_id=0&repo_id=32075541&response-content-disposition=attachment%3B filename%3Dmysqld_exporter-0.14.0.linux-amd64.tar.gz&response-content-type=application%2Foctet-stream

或者从https://github.com/prometheus/mysqld_exporter/releases/tag/v0.14.0 选择要下载的服务器版本。

下载后上传到mysql所在服务器上，并解析。
tar -zxvf mysqld_exporter-0.14.0.linux-amd64.tar.gz -C /usr/local/prometheus/

2、在mysql上创建账号

CREATE USER 'mysql_exporter'@'localhost' IDENTIFIED BY 'Exporter@123' WITH MAX_USER_CONNECTIONS 3;
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'mysql_exporter'@'localhost';
FLUSH PRIVILEGES;

3、在当前用户目录下，创建.my.cnf文件。比如当前为root用户，则在/root下创建，内容如下:

[client]
user=mysql_exporter
password=Exporter@123

4、启动mysql_exporter

nohup ./mysqld_exporter > mysql_exporter.log 2>&1 &

5、配置Prometheus
在Prometheus配置文件prometheus.yml加入如下内容

- job_name: "mysql"
    static_configs:
      - targets: ["localhost:9104"]

然后重启prometheus

ps -ef|grep prometheus
kill -9 xxxx（把上面查询出来的pid填进来）
nohup ./prometheus --config.file=prometheus.yml  > prometheus.log 2>&1 &

6、grafana配置dashboard
导入https://grafana.com/grafana/dashboards/7362

打完收工！

打赏