<Home>
← All templates
database / DEPLOYMENT PRESET

ClickHouse

Private authenticated HTTP analytics database with persistent data.

Before you start

  • HTTP port 8123 on the pod network; the native protocol listens on loopback only, for backups the engine performs itself
  • Persistent storage; one replica; background pools bounded

Configuration that needs your attention

The template provides a bounded XML configuration with a hashed password for the default user.

Private HTTP port 8123 is enabled. The native ClickHouse TCP protocol is not exposed by this preset.

Persistent storage and a 256 MiB query memory budget are explicit. Review these limits for large imports and queries.

Required secrets

Configure these scoped secrets during deployment review in your Hakopod installation. Secret values stay out of the application TOML.

  • database-password

Use this preset

  1. Open the Catalog in your own Hakopod dashboard and select ClickHouse.
  2. Choose the project, environment, and application name. Set the required values and secret references.
  3. Review the generated configuration, resource requests, networking, and storage plan.
  4. Deploy, then inspect readiness and logs. Configure backups for persistent data before relying on the service.

Read the upstream setup documentation ↗

View native TOML and setup notes ↗

Pinned container image

docker.io/clickhouse/clickhouse-server:26.3.33.24@sha256:810861a2e2d0188744f5f23b2d3ec9ff95812bcb9ddbb8fed13a377a7f305893

The catalog pins this image for reproducibility. Review upstream updates and compatibility before changing it.