1.1.1. Prometheus监控MySQL

1.部署MySQL Exporter

[root@dev ~]# cd /usr/local/src
[root@dev src]# wget https://github.com/prometheus/mysqld_exporter/releases/download/v0.13.0/mysqld_exporter-0.13.0.linux-amd64.tar.gz
[root@dev src]# tar zxf mysqld_exporter-0.13.0.linux-amd64.tar.gz
[root@dev src]# mv mysqld_exporter-0.13.0.linux-amd64 /usr/local/
[root@dev src]# ln -s /usr/local/mysqld_exporter-0.13.0.linux-amd64/ /usr/local/mysqld_exporter

2.配置系统服务

[root@dev src]# vim /usr/lib/systemd/system/mysql_exporter.service
[Unit]
Description=https://prometheus.io

[Service]
Restart=on-failure
ExecStart=/usr/local/mysqld_exporter/mysqld_exporter --config.my-cnf=/usr/local/mysqld_exporter/.my.cnf

[Install]
WantedBy=multi-user.target

配置说明

请按照以下步骤配置MySQL监控

1.登录到受监控的MySQL中

[root@dev ~]# mysql -u root -p

2.创建MySQL监控账户并授权

MariaDB [(none)]> CREATE USER 'opsany'@'localhost' IDENTIFIED BY '123456.coM';
MariaDB [(none)]> GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'opsany'@'localhost';

3.配置MySQL监控账户

[root@dev ~]# vim /usr/local/mysqld_exporter/.my.cnf
[client]
user=opsany
password=123456.coM

4.启动监控插件

systemctl daemon-reload
systemctl restart mysql_exporter.service

5.测试

curl http://127.0.0.1:9104/metrics