使用Prometheus对mysql进行监控

一、在被管理机 agent上安装 mysqld_exporter 组件

#下载安装包
wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.15.1/mysqld_exporter-0.15.1.linux-amd64.tar.gz
#解压缩
tar -zxvf /home/rocky/mysqld_exporter-0.15.1.linux-amd64.tar.gz -C /usr/local/
#重命名
mv /usr/local/mysqld_exporter-0.15.1.linux-amd64 /usr/local/mysqlId_exporter

二、在mysql创建用户

CREATE USER 'mysql_monitor'@'localhost' IDENTIFIED BY 'mysql_monitor';
GRANT PROCESS, REPLICATION CLIENT ON *.* TO 'mysql_monitor'@'localhost';

三、创建mysqld_exporter配置文件

/usr/local/mysqlId_exporter/my.cnf
# 粘贴以下代码（注意用户名和密码填写第二步的用户名密码）
[client]
user=mysql_monitor
password=mysql_monitor

四、配置开机自启动

vim /usr/lib/systemd/system/mysqld_exporter.service
# 粘贴以下代码
[Unit]
Description=prometheus_usf_mysql_exporter
Documentation=https://prometheus.io/
After=network.target

[Service]
Type=simple
ExecStart=/usr/local/mysqlId_exporter/mysqld_exporter --web.listen-address=":9104" --config.my-cnf=/usr/local/mysqlId_exporter/my.cnf

Restart=on-failure

[Install]
WantedBy=multi-user.target

五、执行命令

#重新加载
systemctl daemon-reload
#设置服务开机自启
systemctl enable mysqld_exporter
#启动服务
systemctl start mysqld_exporter
#查看服务状态
systemctl status mysqld_exporter

六、修改Prometheus配置文件

vim /usr/local/prometheus/prometheus.yml

# 重启Prometheus并验证
systemctl restart prometheus
systemctl status prometheus

七、测试验证