prometheus+clickhouse-exporter+Grafana配置CH数据库监控

参考里一下其他网上的资源,然后都跑不通,决定自己整折腾了一下。

docker pull prom/prometheus
docker pull f1yegor/clickhouse-exporter

把这玩意儿时区设置成国内, -v 第一个/opt/prometheus.yml配置自己的配置文件路径

sudo docker run --restart always -e TZ=Asia/Shanghai -d -p 9090:9090 -v /opt/prometheus.yml:/etc/prometheus/prometheus.yml -v $PWD/prometheus-data:/prometheus --user "root" --name prometheus prom/prometheus
# my global config                                                                                                                                                                                                                                                             
global:    
  scrape_interval:     15s # Set the scrape interval to every 15 seconds. Default is every 1 minute.    
  evaluation_interval: 15s # Evaluate rules every 15 seconds. The default is every 1 minute.    
  # scrape_timeout is set to the global default (10s).    
    
# Alertmanager configuration    
alerting:    
  alertmanagers:    
  - static_configs:    
    - targets:    
      # - alertmanager:9093    
    
# Load rules once and periodically evaluate them according to the global 'evaluation_interval'.    
rule_files:    
  # - "first_rules.yml"    
  # - "second_rules.yml"    
    
# A scrape configuration containing exactly one endpoint to scrape:    
# Here it's Prometheus itself.    
scrape_configs:    
  # The job name is added as a label `job=<job_name>` to any timeseries scraped from this config.    
  - job_name: 'prometheus'    
    
    # metrics_path defaults to '/metrics'    
    # scheme defaults to 'http'.    
    
    static_configs:    
    - targets: ['localhost:9090']    
    
  - job_name: 'clickhouse_exporter'    
    
    # 覆盖全局的 scrape_interval    
    scrape_interval: 5s    
    
    static_configs:    
    - targets: ['192.168.1.150:9116']    

clickhouse_exporter的IP地址填自己内网IP地址

docker run --env CLICKHOUSE_USER=default --env CLICKHOUSE_PASSWORD=密码 -d -p 9116:9116 f1yegor/clickhouse-exporter -scrape_uri=http://192.168.1.150:8123/  

把自己帐号密码配置一下,启动docker

docker pull grafana/grafana

mkdir /opt/grafana-storage
chmod 777 -R /opt/grafana-storage

docker run -d \
  -p 9998:3000 \
  --name=grafana \
  -v /opt/grafana-storage:/var/lib/grafana \
  grafana/grafana

自己配置一下grafana就行了,默认模板地址  https://grafana.com/grafana/dashboards/882

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值