mysql_exporter安装
1、下载
https://prometheus.io/download/
2、上传服务器、解压至/usr/local/prometheus
#解压
mkdir -p /usr/local/prometheus
tar -zxvf mysqld_exporter-0.15.1.linux-amd64.tar.gz -C /usr/local/prometheus
#重命名
cd /usr/local/prometheus
mv mysqld_exporter-0.15.1.linux-amd64 mysqld_exporter-0.15.1
3、启动
创建一个mysql配置文件,写上连接的用户名与密码
cd /usr/local/prometheus/mysqld_exporter-0.15.1
vim .my.cnf
.my.cnf文件内容:
[client]
user=root
password=111111
host=10.23.190.34
port=3306
启动:
#直接使用默认配置文件,后台启动
nohup /usr/local/prometheus/mysqld_exporter-0.15.1/mysqld_exporter --config.my-cnf=/usr/local/prometheus/mysqld_exporter-0.15.1/.my.cnf &
#确认端口(9104)
lsof -i:9104
4-1、方式一:静态注册:(配置Prometheus)
cd /usr/local/prometheus/prometheus-2.54.0
vim prometheus.yml
添加如下内容:
- job_name: "mysql_exporter"
static_configs:
- targets: ["10.23.190.128:9104"]
重启Prometheus
4-2、方式二:动态注册(通过consul+TenSetS)
不需要配置Prometheus配置文件,只需要在TenSunS控制台添加mysql_exporter服务即可。
consul+TenSunS动态注册上一篇有讲,地址见文档最后。
修改配置文件/usr/local/prometheus/prometheus-2.54.0/prometheus.yml
添加如下内容:
- job_name: 'mysql_exporter'
consul_sd_configs:
- server: '10.23.190.128:8500'
token: 'aba0224c-1f6b-40f1-bb9d-7de86dea9cb5'
services: []
relabel_configs:
- source_labels: [__meta_consul_tags]
regex: .*mysql_exporter.*
action: keep
- regex: __meta_consul_service_metadata_(.+)
action: labelmap
查看Prometheus控制台:
5、service启动(简化启动命令)
service配置
cd /usr/local/prometheus/mysqld_exporter-0.15.1/
vim mysqld_exporter.service
mysqld_exporter.service文件内容:
[Unit]
Description=mysql_exporter
[Service]
ExecStart=/usr/local/prometheus/mysqld_exporter-0.15.1/mysqld_exporter --config.my-cnf=/usr/local/prometheus/mysqld_exporter-0.15.1/.my.cnf --web.listen-address=:9104
Restart=on-failure
[Install]
WantedBy=multi-user.target
软链:
ln -s /usr/local/prometheus/mysqld_exporter-0.15.1/mysqld_exporter.service /etc/systemd/system/mysqld_exporter.service
启动命令:
systemctl daemon-reload
systemctl start mysqld_exporter
systemctl stop mysqld_exporter
systemctl status mysqld_exporter
6、Grafana可视化展示
导入模板:MySQL Exporter Quickstart and Dashboard
模板id:14057
下一篇:prometheus安装部署(七)(process_exporter安装)
上一篇:prometheus安装部署(五)(consul+ConsulManager后羿可视化平台)