Chainguard Container for clickhouse-bitnami

Minimal Wolfi-based ClickHouse analytics database image with compatibility for Bitnami's Helm chart. Clickhouse is the fastest and most resource efficient open-source database for real-time apps and analytics.

Chainguard Containers are regularly-updated, secure-by-default container images.

Download this Container Image

For those with access, this container image is available on cgr.dev:

docker pull cgr.dev/ORGANIZATION/clickhouse-bitnami:latest

Be sure to replace the ORGANIZATION placeholder with the name used for your organization's private repository within the Chainguard Registry.

Compatibility Notes

Chainguard's ClickHouse Bitnami image is comparable to the Bitnami ClickHouse image on Docker Hub. This image leverages all the security features typically provided by Chainguard Images, including low-to-zero CVEs, automated nightly builds, high-quality SBOMs, verifiable signatures, and reproducible builds.

Getting Started

This Chainguard image is compatible with the Bitnami Helm chart for clickhouse.

Create a values.yaml, specifying the Chainguard images:

cat <<EOF > values.yaml
global:
  security:
    allowInsecureImages: true

image:
  registry: "cgr.dev"
  repository: "ORGANIZATION/clickhouse-bitnami"
  tag: "latest"

auth:
  username: "admin"
  password: "SuperS3cret"
EOF

Additionally, the Helm chart includes an init container that manages volume permissions using the os-shell-bitnami image. To use the Chainguard compatible version of this image, include the following in your values.yaml:

volumePermissions:
  enabled: true
  image:
    registry: "cgr.dev"
    repository: "ORGANIZATION/os-shell-bitnami"
    tag: "latest"

Deploy using helm:

helm install clickhouse oci://registry-1.docker.io/bitnamicharts/clickhouse --values values.yaml

You can verify that the deployment was successful with the following command:

kubectl get pods -l app.kubernetes.io/name=clickhouse

Next, run the following command to port forward the ClickHouse service:

kubectl port-forward svc/clickhouse 8123:8123 9000:9000

ClickHouse will now be accessible through the following interfaces:

• HTTP: localhost:8123
• ClickHouse native interface: localhost:9000

To connect using the ClickHouse client, run the following command:

clickhouse-client -h localhost --port 9000 -u admin --password "SuperS3cret"

You can also connect over HTTP using curl:

curl -u admin:SuperS3cret "http://localhost:8123/?query=SELECT+1"

Documentation and Resources

• Bitnami ClickHouse Helm Chart
• Artifact Hub: Bitnami ClickHouse
• Official ClickHouse Documentation

What are Chainguard Containers?

Chainguard Containers are minimal container images that are secure by default.

In many cases, the Chainguard Containers tagged as :latest contain only an open-source application and its runtime dependencies. These minimal container images typically do not contain a shell or package manager. Chainguard Containers are built with Wolfi, our Linux undistro designed to produce container images that meet the requirements of a more secure software supply chain.

The main features of Chainguard Containers include:

• Minimal design, without unnecessary software bloat
• Daily builds to ensure container images are up-to-date with available security patches
• High quality build-time SBOMs attesting to the provenance of all artifacts within the image
• Verifiable signatures provided by Sigstore
• Reproducible builds with Cosign and apko (read more about reproducibility)

For cases where you need container images with shells and package managers to build or debug, most Chainguard Containers come paired with a -dev variant.

Although the -dev container image variants have similar security features as their more minimal versions, they feature additional software that is typically not necessary in production environments. We recommend using multi-stage builds to leverage the -dev variants, copying application artifacts into a final minimal container that offers a reduced attack surface that won’t allow package installations or logins.

Learn More

To better understand how to work with Chainguard Containers, please visit Chainguard Academy and Chainguard Courses.

In addition to Containers, Chainguard offers VMs and Libraries. Contact Chainguard to access additional products.

Trademarks

This software listing is packaged by Chainguard. The trademarks set forth in this offering are owned by their respective companies, and use of them does not imply any affiliation, sponsorship, or endorsement by such companies.