一、node_exporter与mysqld_exporter的区别
1.安装了node_exporter -->获取mysql服务器的cpu、内存、磁盘IO、网络IO、进程等信息
监听:9090
2.安装mysqld_exporter -->获取MySQL内部的性能指标
监听:9104
接下来我们安装mysqld_exporter代理程序
1、在mysql服务器上登录MySQL
2、创建用于获取mysqld进程信息的数据库的用户exporter
CREATE USER 'exporter'@'%' IDENTIFIED BY 'Sanchuang123' WITH MAX_USER_CONNECTIONS 3;
对用户exporter进行授权,授予PROCESS, REPLICATION CLIENT, SELECT 三种权限,在任何的库里的任何表上。
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'%';
3、部署mysqld_exporter
需要提前上传下载的mysqld_exporter-0.15.0.linux-amd64.tar.gz
tar xf mysqld_exporter-0.15.1.linux-amd64.tar.gz -C /usr/local
cd /usr/local/
mv mysqld_exporter-0.15.0.linux-amd64 mysqld_exporter
cd mysqld_exporter/
ls
.my.cnf是mysqld_exporter用于登录mysqld进程的配置文件
vim .my.cnf
[client]
user=exporter
password=Sanchuang123
4、将mysqld_exporter做成服务
vim /usr/lib/systemd/system/mysqld_exporter.service
[Unit]
Description=mysqld_exporter
[Service]
Environment=DATA_SOURCE_NAME=exporter:Sanchuang123@(localhost:3306)/
ExecStart=/usr/local/mysqld_exporter/mysqld_exporter --config.my-cnf=/usr/local/mysqld_exporter/.my.cnf --web.listen-address=:9104
Restart=on-failure
[Install]
WantedBy=multi-user.target
systemctl daemon-reload
systemctl enable mysqld_exporter
systemctl restart mysqld_exporter
5、在Prometheus.yml中添加mysqld_exporter的配置
vim /prom/prometheus/prometheus.yml
- job_name: "db_mysqld_exporter"
static_configs:
- targets: ["192.168.203.147:9104"]
重启prometheus服务
systemctl restart prometheus
登录网站查看效果
6、6.Grafana里添加支持mysqld_exporter模板
添加mysqld_exporter模板