ClickHouse

Overview
ClickHouse on OneCloudPlanet — the columnar database for analytics: events, logs, product metrics and clickstreams. Queries over billions of rows in seconds.

What is ClickHouse?
The fastest open OLAP database: columnar storage, aggressive compression, SQL. The standard for product analytics and time series.

Why on OneCloudPlanet?
NVMe + dedicated vCPUs: scan gigabytes per second.
Recommended configuration: 4 vCPU / 8 GB to start. See pricing.
Cheaper than cloud DWH: fixed price versus pay-per-scan.
Pairs with Metabase from Marketplace for instant BI.

How to launch
1) Sign in at console.ocplanet.cloud
2) Open Marketplace and choose ClickHouse
3) Pick a configuration and location
4) Wait for deploy
5) Change the default credentials

Post-deploy checklist
• Set the default user password
• Close ports 8123/9000 with Firewall
• Partition by date
• Cold partitions to Object Storage (S3 disk)

FAQ
What is it NOT for? Transactions (OLTP) — use PostgreSQL; ClickHouse is for analytics.
Capacity? 5–10x compression: a terabyte of raw events ≈ 100–200 GB on disk.