部署mysqld_exporter，接入Prometheus，grafana dashboard显示

部署mysqld_exporter

cd /usr/local

wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.15.0/mysqld_exporter-0.15.0.linux-amd64.tar.gz

tar -zxvf mysqld_exporter-0.15.0.linux-amd64.tar.gz

mv mysqld_exporter-0.15.0.linux-amd64 mysqld_exporter

cd mysqld_exporter

cat > .my.cnf <<EOF

[client]

user=数据库用户名

password=数据库密码

EOF

cat >/usr/lib/systemd/system/mysqld_exporter.service <<EOF

[Unit]

Description=mysqld_exporter

[Service]

Environment=DATA_SOURCE_NAME=数据库用户名:数据库密码@(数据库ip:数据库端口)/

ExecStart=/usr/local/mysqld_exporter/mysqld_exporter --config.my-cnf=/usr/local/mysqld_exporter/.my.cnf --web.listen-address=:9104

Restart=on-failure

[Install]

WantedBy=multi-user.target

EOF

systemctl daemon-reload

systemctl start mysqld_exporter

systemctl status mysqld_exporter

systemctl enable mysqld_exporter

netstat -lnp  |  grep 9014

接入Prometheus

vi  prometheus.yml

global:
  scrape_interval: 15s

scrape_configs:
  - job_name: 'mysql'
    static_configs:
      - targets: ["192.168.0.777:9104"]

 grafana dashboard显示，导入模板

MySQL Exporter Quickstart and Dashboard | Grafana Labs

注意：适配的版本，版本不对会报异常，如Failed to upgrade legacy queries e.replace is not a function