1.安装mysql_exporter和授权
概述: mysql_exporter是用来收集MysQL数据库相关指标的,mysql_exporter需要连接到数据库并有相关权限。我这里是远程收集数据库所以需要数据库内有一个用户拥有远程权限
数据库开启远程权限
# 自己创建一个用户或原本的(我这里是主从,所以这里我授了主从) > grant all on *.* to root@"%" with grant option; > flush privileges;
## 下载文件(绿色软件可直接使用) ~]# export VER=0.12.1 ~]# wget https://github.com/prometheus/mysqld_exporter/releases/download/v${VER}/mysqld_exporter-${VER}.linux-amd64.tar.gz ~]# tar xvf mysqld_exporter-${VER}.linux-amd64.tar.gz ~]# mv mysqld_exporter-${VER}.linux-amd64/mysqld_exporter /usr/local/bin/ ~]# chmod +x /usr/local/bin/mysqld_exporter ~]# cd /usr/local/bin/mysqld_exporter # 书写配置 ~]# vim .my.cnf [client] host=主-ip port=mysql端口 user=用户 password=密码 ~]# cat .my2.cnf [client] host=从-ip port=3306 user=root password=密码
启动
./mysqld_exporter --config.my-cnf=.my.cnf --collect.slave_status &
2.安装redis_exporter和启动
## 下载就可以直接用了(绿色软件) wget https://github.com/oliver006/redis_exporter/releases/download/v1.3.2/redis_exporter-v1.3.2.linux-amd64.tar.gz tar -xf redis_exporter-v1.3.2.linux-amd64.tar.gz cd redis_exporter-v1.3.2.linux-amd64/ ./redis_exporter -redis.addr redis的ip:端口 -redis.password 密码 & # 注意redis数据要开启远程登录权限
3.最后在节点添加监听节点
注:这里我是用容器部署的,已经把容器目录挂载到本地,所以直接在本地修改重启容器就好了
# 在prometheus服务主配置文集中添加 ~]# vim prometheus.yml global: scrape_interval: 60s evaluation_interval: 60s alerting: alertmanagers: - static_configs: - targets: ["10.16.0.31:9093"] #rule_files: # - "/etc/prometheus/rule.yml" scrape_configs: - job_name: 'prometheus' static_configs: - targets: ["10.16.0.31:9090"] - job_name: 'node-exporter' static_configs: - targets: ["10.16.0.31:9111","10.16.0.38:9111","10.16.0.46:9111"] - job_name: 'alertmanager' static_configs: - targets: ["10.16.0.31:9093"] - job_name: "mysql" # 添加数据库的结点 static_configs: - targets: ['mysqld_exporter的ip:9104'] labels: instance: 'mysql主ip' - targets: ['mysqld_exporter的ip:9104'] labels: instance: 'mysql从ip' - job_name: 'redis' # 添加redis节点 static_configs: - targets: ['redis_exporter的ip:9121'] labels: instance: 'redis主ip' - targets: ['redis_exporter的ip:9121'] labels: instance: 'redis从ip'
4.查看