Prometheus + Granfana + mysqld_exporter 监控MySQL数据库

Prometheus + Granfana + mysqld_exporter 监控MySQL数据库
参照：
https://www.cnblogs.com/xiangsikai/p/11289675.html


iptables -I INPUT 11 -p tcp --dport 9104 -j ACCEPT
/etc/init.d/iptables save

groupadd prometheus
useradd -g prometheus -m -d /opt/prometheus/ -s /sbin/nologin prometheus

tar xf mysqld_exporter-0.12.1.linux-amd64.tar.gz -C /usr/local/
cd /usr/local
mv mysqld_exporter-0.12.1.linux-amd64 mysqld_exporter
cd /usr/local/mysqld_exporter/
touch .my.cnf
cat >>.my.cnf<<EOF
[client]
user=exporter
password=xxxxxyyyyy
EOF

chown -R prometheus:prometheus mysqld_exporter

mysql -u root -p
GRANT SELECT, PROCESS, SUPER, REPLICATION CLIENT, RELOAD ON *.* TO 'exporter'@'172.xx.xx.xx' IDENTIFIED BY 'xxxxxxyyyy';
flush privileges;

./mysqld_exporter --config.my-cnf=.my.cnf &
lsof -i:9104

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

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

systemctl daemon-reload
systemctl restart mysqld_exporter.service   
   
#如果启动失败，可以直接到文件目录下后台运行mysqld_exporter
cd /usr/local/mysqld_exporter/
chown -R prometheus:prometheus mysqld_exporter
./mysqld_exporter --config.my-cnf=.my.cnf &
 lsof -i:9104

#服务端Prometheus 添加对mysqld_exporter端的监控

vi /usr/local/prometheus/prometheus.yml
- job_name: 'xxx_db'
  static_configs:
    - targets: ['172.xx.xx.xx:9104']
      labels:
        instance: xxxx_db_yyy


./promtool check config prometheus.yml
systemctl restart prometheus
systemctl restart grafana-server

+ ==》 import==》Grafana.com Dashboard:输入 7362 ==》prometheus:Prometheus==》Import

Granfana 导入Mysql 监控图表
推荐图标ID：https://grafana.com/dashboards/7362