User-defined Playground  by Márk Sági-Kazár

ClickHouse Cluster Playground

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

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

💡 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

🧩 Related Content

🧪 Playgrounds

Happy clustering! 🚀