ClickHouse

ClickHouse: Column-oriented OLAP database for fast analytical queries at scale. Deploy ClickHouse for real-time analytics over billions of rows.

Deploy from this page: TryDirect provisions the server, starts the services, generates the deployment credentials and wires the 1 containers together. Nothing is shared between deployments and no secrets ship with the stack.

What's included

Service	Port	Description
app	8123 (public), 9000 (public)	Database

What you configure

• Domain (commonDomain): the hostname the stack is served on
• Defaults provided: CLICKHOUSE_DB, CLICKHOUSE_USER ship prefilled and can be adjusted in the deploy form

All 1 credential (passwords and keys) are generated per deployment and stored in your project's secret store.

Requirements

• A cloud account connected to TryDirect (the deploy form provisions

the server) or one of your own servers

• A server that fits 1 containers (2 GB RAM or more recommended)
• A DNS record for the domain you set in the deploy form

Alternative: deploy with the Stacker CLI

Everything above also works from the command line:

git clone https://github.com/trydirect/awesome-selfhosted-stacker.git
cd awesome-selfhosted-stacker/stacker-projects/clickhouse

# Generate secrets
cp .env.example .env
./scripts/generate-secrets.sh

# Deploy
stacker deploy