ClickHouse Cluster
Sharded, replicated analytics clusters
Deploy production-ready ClickHouse clusters with configurable shards and replicas. Includes ClickHouse Keeper for coordination, CHProxy for load balancing, and optional S3 backups with tiered storage.
Sharding & Replication
Configure your cluster topology with flexible sharding and replication. Each shard can have multiple replicas for high availability and data redundancy.
- Dynamic shard configuration: Set the number of shards based on your data distribution needs
- Multi-replica support: Each shard can have multiple replicas for fault tolerance
- Automatic data distribution: ClickHouse handles data distribution across shards automatically
ClickHouse Keeper Coordination
ClickHouse Keeper provides distributed coordination for your cluster without external dependencies like ZooKeeper.
- Built-in coordination: No need for external ZooKeeper clusters
- Odd-numbered quorum: Deploy 3, 5, or 7 keeper nodes for optimal performance
- Automatic leader election: Handles failover automatically
CHProxy Load Balancing
CHProxy provides intelligent load balancing and query routing for your ClickHouse cluster.
- Smart query routing: Routes queries to the optimal node based on load
- Connection pooling: Efficient connection management for high-throughput workloads
- Health monitoring: Automatic detection and routing around unhealthy nodes
S3 Backups
Integrated backup and restore with S3-compatible storage for reliable disaster recovery.
- Automated backups: Schedule regular backups to S3-compatible storage
- Point-in-time recovery: Restore to any point in time from backup history
- Cross-region replication: Store backups in different regions for disaster recovery
Hot & Cold Storage
Optimize costs with automatic data tiering between hot and cold storage. Simply define your cold storage location and ClickHouse handles the rest.
- Automatic tiering: Data moves to cold storage based on age or access patterns
- S3-compatible cold storage: Use any S3-compatible storage for cold data
- Transparent access: Query hot and cold data seamlessly—no application changes needed
- Cost optimization: Keep frequently accessed data on fast storage, archive the rest
Helper script to restore broken replicas
Each ClickHouse node includes a restore_replica.sh script that can recover a failed replica by streaming metadata and access control data from a healthy peer in the same shard. The script automatically stops the local container, transfers the necessary files via SSH, sets proper ownership, creates a force_restore_data flag, and restarts ClickHouse. This allows you to quickly restore a replica without manual intervention or complex recovery procedures.
Visual Config Editor
Customize your ClickHouse configuration without editing raw XML files. Our visual config editor layers your customizations on top of battle-tested defaults.
- Pre-configured defaults: Start with production-ready settings tuned for performance
- Override anything: Add custom settings that merge with our defaults
- No config conflicts: Your changes apply cleanly without breaking core functionality
- Version controlled: Track configuration changes across deployments
FAQ
Frequently Asked Questions
Common questions about this deployment recipe.
Simple, one-time pricing
Pay once, get free updates for a year. After that, pay again to continue receiving updates.
50 spots remaining
One-time payment • Free updates for 1 year
- All database recipes (and upcoming recipes)
- Unlimited servers
- All cloud providers
- Server hardening
- Monitoring stack
- AI-powered diagnostics
- Cross-region replicas
- Free updates for 1 year
After 1 year, pay again to continue receiving updates
Other Recipes
Explore our other production-ready database clusters.
PostgreSQL + Patroni
Deploy production-ready PostgreSQL clusters with Patroni for automatic failover, etcd for coordination, PgBouncer for connection pooling, and optional HAProxy for read/write splitting. Includes pgBackRest for backups and support for cross-region read replicas.
Redis Sentinel
Deploy Redis clusters with Sentinel for automatic failover and HAProxy for master routing. Support for cross-region replicas enables faster reads and geo-distributed caching.