Hacker News Reader

Clickhouse is great but the ops and scaling make it notoriously difficult to self host.

If you have a lot of log data and want something open source and serverless you can self host, check out Matano (https://github.com/matanolabs/matano).

View on HN

Clickhouse is known for being super easy to run and operate vs peers. A single binary and very simple configuration.

The only acknowledged downside is that it does not have automatic rebalancing of data if new nodes are added.

Exactly, getting started is easy but dealing with scaling and operations when it's deployed in a production environment is not simple, primarily because it doesn't separate storage and compute.

I think ClickHouse Cloud Beta addressed exactly this concern. It separates storage and compute and deals with scaling. There is no sharding so you don't need to deal with scaling.

Reply on news.ycombinator.com