[RhodesianHunter]

I have not found this to be the case. Like any system you need to take precautions (replicas and sharding) to ensure no data loss, but I didn't find that to be challenging. In what way have you found ClickHouse particularly risky in this way?

[willvarfar]

It’s basic computer science. Clickhouse doesn’t fsync etc.

Clickhouse (and other systems with the same basic architecture, like elastic search and, shudder, mongodb) work very well on happy path. They are not advertising themselves as ACID.

[qoega]

You can enable fsync in ClickHouse. And it will not decrease bandwidth.

[jd_mongodb]

MongoDB has ACID support.