ClickHouse Cluster Playground
A multi-node cluster for exploring scaling capabilities of ClickHouse.
- eth0
- /
- oci://ghcr.io/sagikazarmark/iximiuz-labs/playgrounds/clickhouse-cluster:live@sha256:0df909dbc612428abc8a1f0dad3e484b794636cb241ea436582b83f2bc61dd90
- eth0
- /
- oci://ghcr.io/sagikazarmark/iximiuz-labs/playgrounds/clickhouse-cluster:live@sha256:0df909dbc612428abc8a1f0dad3e484b794636cb241ea436582b83f2bc61dd90
- eth0
- /
- oci://ghcr.io/sagikazarmark/iximiuz-labs/playgrounds/clickhouse-cluster:live@sha256:0df909dbc612428abc8a1f0dad3e484b794636cb241ea436582b83f2bc61dd90
- eth0
- /
- oci://ghcr.io/sagikazarmark/iximiuz-labs/playgrounds/clickhouse-cluster:live@sha256:0df909dbc612428abc8a1f0dad3e484b794636cb241ea436582b83f2bc61dd90
๐ก For use cases that don't require ClickHouse's scaling capabilities, you can use this single-node playground.
๐ง System Components
- ClickHouse Server: High-performance columnar database engine optimized for analytics
- ClickHouse Keeper: Distributed coordination service for cluster management
๐ ๏ธ Tools
clickhouse-client: Interactive command-line client for running queriesclickhouse-local: Tool for processing local files with ClickHouse SQL
๐ฏ Getting Started
Connecting to the Cluster
# Connect to any node in the cluster
clickhouse-client
# Connect with specific database
clickhouse-client --database=default
# Execute single query
clickhouse-client --query "SELECT version()"
# Check cluster configuration
clickhouse-client --query "SELECT * FROM system.clusters"
Credentials
If you need to connect from another client, use the following credentials:
- Host:
localhost(any cluster node) - Port:
9000(native) or8123(HTTP) - Username:
default - Password:
iximiuz - Database:
default
๐ Learn More
๐งฉ Related Content
๐งช Playgrounds
Happy clustering! ๐
A real VM, not a container
Get root on a VM with its own kernel, so Docker, Kubernetes, and systemd just work.
Read the docs โ
SSH from browser or CLI
Use the built-in web terminal, or connect with labctl ssh, plain ssh, scp, or rsync.
Read the docs โ
Drive it with AI
Let Claude, Codex, or any MCP client start this playground and run commands in it.
Read the docs โ
Expose HTTP(S) ports
Give any web app running inside the VM a public URL - for yourself or to share with others.
Read the docs โ
Share terminals
Invite others into your terminal session, or open it yourself from another device.
Read the docs โ
Customize with init scripts
Add shell scripts that run at boot to install packages, clone repos, or seed test data.
Read the docs โ
Private networking
VMs reach the internet via NAT with no public IP; several VMs share bridge networks.
Read the docs โ
Ephemeral or persistent
By default, VMs are destroyed when the session ends; enable persistence to keep the disks for next time.
Read the docs โ
Built-in container registry
A private registry.iximiuz.com for every playground to share images across services and VMs.
Read the docs โ