Grafana+Prometheus+mysqld_exporter监控mysql

mysqld_exporter 下载链接
https://github.com/prometheus/mysqld_exporter/releases/download/v0.13.0/mysqld_exporter-0.13.0.linux-amd64.tar.gz
下载完成上传到服务器

#定位到安装目录下
cd /usr/local
#将下载到本地的文件上传到Linux服务器
rz
#解压文件
tar -xzvf mysqld_exporter-0.13.0.linux-amd64.tar.gz
#将文件目录名改为mysqld_exporter
mv mysqld_exporter-0.13.0.linux-amd64 mysqld_exporter


在配置文件里面添加账户密码
vim /etc/my.cnf
[client]
user&＃61;root
password&＃61;密码


启动

./mysqld_exporter --config.my-cnf&＃61;/etc/my.cnf


添加系统服务 vim /usr/lib/systemd/system/mysqld_exporter.service

[Unit]
Description&＃61;https://prometheus.io[Service]
Restart&＃61;on-failure
ExecStart&＃61;/usr/local/mysqld_exporter/mysqld_exporter --config.my-cnf&＃61;/etc/my.cnf[Install]
WantedBy&＃61;multi-user.target


启动系统服务

systemctl daemon-reload
systemctl start mysqld_exporter
systemctl restart mysqld_exporter.service
systemctl status mysqld_exporter


用浏览器打开服务器IP:9104

下载链接 下载完成上传到服务器
https://github.com/prometheus/prometheus/releases/download/v2.29.1/prometheus-2.29.1.linux-amd64.tar.gz

tar -xzvf prometheus-2.29.1.linux-amd64.tar.gz
mv prometheus-2.29.1.linux-amd64 /usr/local/
mv prometheus-2.29.1.linux-amd64 prometheus


解压后当前目录会包含默认的Prometheus配置文件promethes.yml&＃xff0c;配置Prometheus监控设置. vim prometheus.yml

scrape_configs:# 添加作业并命名- job_name: &＃39;mysql&＃39;# 静态添加nodestatic_configs:# 指定监控端- targets: [&＃39;数据库服务器IP:9104&＃39;]


Systemd服务启动prometheus
vim /etc/systemd/system/prometheus.service

[Unit]
Description&＃61;Prometheus
Documentation&＃61;https://prometheus.io/
After&＃61;network.target
[Service]
ExecStart&＃61;/usr/local/prometheus/prometheus --config.file&＃61;/usr/local/prometheus/prometheus.yml --storage.tsdb.path&＃61;/data/prometheus
Restart&＃61;on-failure
[Install]
WantedBy&＃61;multi-user.target


启动 访问prometheus&＃xff0c;服务器IP地址:9090

systemctl daemon-reload
systemctl start prometheus
systemctl restart prometheus
systemctl status prometheus
systemctl enable prometheus


wget https://dl.grafana.com/oss/release/grafana-8.1.2-1.x86_64.rpm
sudo yum install grafana-8.1.2-1.x86_64.rpm
service grafana-server restart


访问grafana&＃xff0c;服务器IP地址:3000 admin/admin

添加数据源Prometheus


点击import导入仪表盘