Service Replica Service Replica Service User Config Map Common Config Map Stateful Set Pod Persistent Volume Claim Persistent Volume Per-replica Config Map Altinity ClickHouse Operator created $ kubectl get all -n demo NAME READY STATUS RESTARTS AGE pod/chi-demo-01-demo-0-0-0 1/1 Running 0 37s NAME TYPE NAME READY STATUS RESTARTS AGE pod/chi-demo-01-demo-0-0-0 1/1 Running 0 2m pod/chi-demo-01-demo-1-0-0 1/1 Running 0 33s NAME

Service Replica Service Replica Service User Config Map Common Config Map Stateful Set Pod Persistent Volume Claim Persistent Volume Per-replica Config Map Challenges running ClickHouse created $ kubectl get all -n demo NAME READY STATUS RESTARTS AGE pod/chi-a82946-2946-0-0-0 1/1 Running 0 52s NAME TYPE test # Connect to specific node clickhouse-client --host chi-a82946-2946-0-0.test # Connect via pod entry kubectl exec -it chi-a82946-2946-0-0-0 -n demo -- clickhouse-client Connect from outside

虚拟集群最少两台机器在不同的机房； Ø 数据独立，多写，相互不干扰； Ø 数据读取通过应用程序做负载平衡； Ø 灵活创建不同的虚拟集群用于适当的场合； Ø 随时调整服务器，新增/缩减服务器； 分布式： k8s的集群式部署 全球敏捷运维峰会 广州站 采用ClickHouse后平台的查询性能 system.query_log表，记录已经 执行的查询记录 query：执行的详细SQL，查询相关记录可以