ClickHouse
The fastest and most resource efficient open-source database for real-time apps and analytics
What is ClickHouse?
ClickHouse is a fast open-source column-oriented database management system that allows generating analytical data reports in real-time using SQL queries.
Key Features
- Column-oriented storage for fast analytics
- Real-time query processing
- SQL support with extensions
- Linear scalability
- Data compression
- Vectorized query execution
- Replication and sharding
Deployment on Moltern
ClickHouse can be deployed on Moltern with a single click. Moltern handles:
- Automatic SSL/TLS certificates via Let's Encrypt
- Persistent storage for your data
- Environment configuration through the dashboard
- Container orchestration with automatic restarts
Getting Started
- Navigate to the Services page in Moltern
- Search for "ClickHouse"
- Click Deploy and configure your settings
- Access your instance via the provided URL
Configuration
Environment Variables
Configure the following environment variables in your Moltern dashboard:
| Variable | Description | Default |
|---|---|---|
| Check service settings | Configure via dashboard | - |
Backup
Plan a backup using the service's own export or backup tools before deleting data. A restart is not a backup.