使用 Prometheus 监控 MySQL 数据库

部署 mysqld_exporter

1. 下载 mysqld_exporter 二进制包

wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.12.1/mysqld_exporter-0.12.1.linux-amd64.tar.gz -O /data/mysqld_exporter-0.12.1.linux-amd64.tar.gz

1. 解压缩并移动至指定目录

tar -zxvf /data/mysqld_exporter-0.12.1.linux-amd64.tar.gz -C /data/
mv /data/mysqld_exporter-0.12.1.linux-amd64 /data/mysqld_exporter

1. 创建 MySQL 监控用户并授权

GRANT SELECT, PROCESS, SUPER, REPLICATION CLIENT, RELOAD ON *.* TO 'mysql_monitor'@'%' IDENTIFIED BY 'exporter_mysql';
FLUSH PRIVILEGES;

1. 配置 mysqld_exporter

cat >/data/mysqld_exporter/.my.cnf<<EOF
[client]
user=mysql_monitor
password=exporter_mysql
EOF

1. 启动 mysqld_exporter

cd /data/mysqld_exporter/
nohup ./mysqld_exporter --config.my-cnf=.my.cnf > /dev/null