部署包下载地址: https://github.com/prometheus/mysqld_exporter/releases
1.根据服务器情况选择安装目录,上传安装包。
tar -xvzf mysqld_exporter-0.14.0.linux-amd64.tar.gz
mv mysqld_exporter-0.14.0.linux-amd64 mysqld_exporter
cd mysqld_exporter
2.创建配置文件
创建配置文件.my.cnf
,填入如下内容后保存:wq
[client]
user = exporter
password = <your password>
host = 11x.xx.xx.7
port = <your port>
MySQL创建用户并授权,注意服务ip不要填错
CREATE USER 'exporter'@'<安装Prometheus的主机IP>' IDENTIFIED BY '<your password>';
GRANT PROCESS, REPLICATION CLIENT, SELECT ON *.* TO 'exporter'@'<安装Prometheus的主机IP>';
flush privileges;
三.进行系统service编写
创建mysqld_exporter.service
配置文件
cd /usr/lib/systemd/system
vim mysqld_exporter.service
mysqld_exporter.service 文件填入如下内容后保存:wq
安装目录根据实际情况修改
[Unit]
Description=https://prometheus.io
[Service]
Restart=on-failure
ExecStart=/root/mysqld_exporter/mysqld_exporter --config.my-cnf=/root/mysqld_exporter/.my.cnf --web.listen-address=:9105
[Install]
WantedBy=multi-user.target
刷新服务配置并启动服务,查看服务运行状态,设置开机自启
systemctl daemon-reload
systemctl start mysqld_exporter.service
systemctl status mysqld_exporter.service
systemctl enable mysqld_exporter.service
测试服务返回(有模块监控参数返回表示正常)
curl localhost:9105/metrics
对接prometheus
打开prometheus_configmap.yml
添加以下内容,并执行:wq
,点击回车保存
# 监控mysql
- job_name: 'mysql'
static_configs:
- targets: ['11x.xx.xx.7:9104']
labels:
instance: mysqld-exporter
执行prometheus配置刷新
curl -XPOST localhost:9090/-/reload
打开prometheus,搜索mysql,可以看到出现了很多的参数指标
打开targets,可以看到节点状态已经UP
至此mysqld-exporter插件安装完毕