clickhouse-prod-checklist

# ClickHouse Production Checklist ## Overview Comprehensive go-live checklist for ClickHouse covering server tuning, schema design, backup configuration, monitoring, and operational readiness. ## Prerequisites - ClickHouse instance provisioned (Cloud or self-hosted) - Application integration code tested in staging ## Checklist ### 1. Schema & Engine Design - [ ] Tables use `MergeTree` family engines (not `Memory`, `Log`, or `TinyLog`) - [ ] `ORDER BY` columns match primary filter/group patterns - [ ] `PARTITION BY` is coarse (monthly or weekly, never by ID) - [ ] `TTL` configured for data retention policy - [ ] `LowCardinality(String)` used for low-cardinality columns - [ ] `CODEC(ZSTD)` applied to large String/JSON columns - [ ] ReplacingMergeTree used with `FINAL` or dedup logic if upserts needed ### 2. Server Configuration (Self-Hosted) ```xml <!-- Key production settings in config.xml / users.xml --> <!-- Memory: set to ~80% of available RAM --> <max_server_memory_usage_to_ram_ratio>0.8</max_server_memory_usage_to_ram_ratio> <!-- Query limits --> <max_concurrent_queries>150</max_concurrent_queries> <max_memory_usage>10000000000</max_memory_usage> <!-- 10GB per query --> <max_execution_time>300</max_execution_time> <!-- 5 min timeout --> <!-- Merge settings --> <background_pool_size>16</background_pool_size> <background_schedule_pool_size>16</background_schedule_pool_size> <!-- Logging --> <query_log> <database>system</database> <table>query_log...