User-defined Playground

ClickHouse Cluster Playground

Mรกrk Sรกgi-Kazรกr
byย  Mรกrk Sรกgi-Kazรกrย ยทย on
Linux

A multi-node cluster for exploring scaling capabilities of ClickHouse.

ClickHouse Cluster playground: A multi-node cluster for exploring scaling capabilities of ClickHouse.
Machines & network
4 VMs ยท 8 vCPU ยท 16GiB RAM
Playground host Internet NAT MASQUERADE local (bridge) 172.16.0.0/24 gw 172.16.0.1/24eth0eth0eth0eth0
VM
vCPU ยท
eth0
/
oci://ghcr.io/sagikazarmark/iximiuz-labs/playgrounds/clickhouse-cluster:live@sha256:0df909dbc612428abc8a1f0dad3e484b794636cb241ea436582b83f2bc61dd90
VM
vCPU ยท
eth0
/
oci://ghcr.io/sagikazarmark/iximiuz-labs/playgrounds/clickhouse-cluster:live@sha256:0df909dbc612428abc8a1f0dad3e484b794636cb241ea436582b83f2bc61dd90
VM
vCPU ยท
eth0
/
oci://ghcr.io/sagikazarmark/iximiuz-labs/playgrounds/clickhouse-cluster:live@sha256:0df909dbc612428abc8a1f0dad3e484b794636cb241ea436582b83f2bc61dd90
VM
vCPU ยท
eth0
/
oci://ghcr.io/sagikazarmark/iximiuz-labs/playgrounds/clickhouse-cluster:live@sha256:0df909dbc612428abc8a1f0dad3e484b794636cb241ea436582b83f2bc61dd90
About
Note

๐Ÿ’ก 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 queries
  • clickhouse-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) or 8123 (HTTP)
  • Username: default
  • Password: iximiuz
  • Database: default

๐Ÿ“š Learn More

๐Ÿงช Playgrounds

Happy clustering! ๐Ÿš€

Every playground includes
Learn more about playgrounds
Start
Settings