0xtaos / ch-examples

ClickHouse Examples

ClickHouse Examples

ClickHouse Blog data

A collection of data required to back our own ClickHouse official Blogs, including:

• DDL statements;
• SQL queries;
• a collection of agents (Vector, FluentBit, etc) configurations to analyze Kubernetes logs in Clickhouse;
• more;

ClickHouse docker compose recipes

A list of ClickHouse docker compose recipes:

• ClickHouse and Grafana
• ClickHouse and Minio S3
• Clickhouse and LDAP (OpenLDAP)
• ClickHouse and Postgres
• Clickhouse and Vector syslog and apache demo data
• Clickhouse Cluster: 2 CH nodes - 3 ClickHouse Keeper (1 Shard 2 Replicas)
• Clickhouse Cluster: 2 CH nodes - 3 ClickHouse Keeper (2 Shards 1 Replica)
• Clickhouse Cluster: 4 CH nodes - 3 ClickHouse Keeper (2 Shards 2 Replicas)
• Clickhouse Cluster: 2 CH nodes - 3 ClickHouse Keeper (1 Shard 2 Replicas) - CH Proxy LB
• Clickhouse Cluster: 2 CH nodes - 3 ClickHouse Keeper (2 Shards 1 Replica) - CH Proxy LB
• Clickhouse Cluster: 4 CH nodes - 3 ClickHouse Keeper (2 Shards 2 Replicas) - CH Proxy LB
• Clickhouse Cluster: 4 CH nodes - 3 ClickHouse Keeper (2 Shards 2 Replicas) with inter-nodes and keeper digest authentication

These recipes are meant to provide a quick n dirty way to get started and try out specific type of ClickHouse integration or clustered environment locally.

See this page to get started using ClickHouse docker compose recipes.

Last but not least, feel free to contribute by submitting a PR!