添加clickhouse监控

添加clichouse-exporter-deployment

vim prometheus-clickhouse-exporter-deployment.yaml
apiVersion: apps/v1
kind: Deployment
metadata:
  namespace: monitoring
  name: clickhouse-exporter
  labels:
    k8s-app: clickhouse
spec:
  replicas: 1
  selector: 
    matchLabels:
      k8s-app: clickhouse
  template:
    metadata:
      labels:
        k8s-app: clickhouse
    spec:
      terminationGracePeriodSeconds: 10
      containers:
      - name: clickhouse-exporter
        image: 10.111.9.72/prometheus/clickhouse-exporter:latest
        args:
          - -scrape_uri=http://10.111.12.72:18123
        ports:
          - containerPort: 9116
            name: clickhouse
        volumeMounts:
          - mountPath: /etc/localtime
            name: localtime
        env:
        - name: CLICKHOUSE_USER
          value: flycua
        - name: CLICKHOUSE_PASSWORD
          value: mHLs3EYgqpdxSpYSUPxVUCT3w9o=
      volumes:
        - hostPath:
            path: /etc/localtime
            type: File
          name: localtime
      nodeSelector:
        decided: system
      tolerations:
      - key: decided
        operator: Equal
        value: system
        effect: NoSchedule

添加clickhouse-svc

vim prometheus-clickhouse-exporter-svc.yaml
---
apiVersion: v1
kind: Service
metadata:
  name: clickhouse-exporter
  namespace: monitoring
  labels:
    k8s-app: clickhouse
spec:
  selector:
    k8s-app: clickhouse
  type: ClusterIP
  clusterIP: None
  ports:
  - protocol: TCP
    port: 9116
    name: metrics

添加clichouse serviceMonitor

vim prometheus-clickhouse-exporter-serviceMonitor.yaml
apiVersion: monitoring.coreos.com/v1
kind: ServiceMonitor
metadata:
  name: clickhouse-exporter
  namespace: monitoring
  labels:
    k8s-app: clickhouse
spec:
  jobLabel: k8s-app
  endpoints:
  - port: metrics
    interval: 30s
    scheme: http
  selector:
    matchLabels:
      k8s-app: clickhouse
  namespaceSelector:
    matchNames:
    - monitoring

grafana模板视图见 https://grafana.com/grafana/dashboards/882 或附件