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