ClickHouse

ClickHouse provides OLAP analytics capabilities for real-time aggregations, time-series analysis, and high-throughput analytical queries.

Architecture

ClickHouse is deployed as a StatefulSet with SSD-backed storage for columnar data:

resources:
  requests:
    cpu: "2"
    memory: "8Gi"
  limits:
    cpu: "4"
    memory: "16Gi"
 
persistence:
  enabled: true
  storageClass: ssd
  size: 100Gi

Service Connection

# From ai-service values
config:
  clickhouse:
    host: "clickhouse.matih-data-plane.svc.cluster.local"
    port: 8123
    user: "default"
    database: "default"

Use Cases

Use Case	Query Pattern
Real-time dashboards	Aggregation over time windows
Metric storage	Prometheus remote write backend
Event analytics	Kafka consumer to materialized views
Cost analytics	Billing event aggregation

MinIO Flink