Re:ClickHouse as an alternative to Elasticsearch for log sto...
by AurimasJLT on Tuesday March 02, 2021 @01:40PM
(#26318733)
Yeah Druid got blown away by ClickHouse at eBay
Druid 700+ servers versus 2 region fully replicated ClickHouse system of 40 nodes.
https://tech.ebayinc.com/engineering/ou-online-analytical-pr...
and a webinar they did with us at Altinity
https://www.youtube.com/watch?v=KI0AqpmcSOk&t=20s
Re:ClickHouse as an alternative to Elasticsearch for log sto...
by mgachka on Tuesday March 02, 2021 @05:45PM
(#26322178)
FYI, we're using clickhouse since 2018 at ContentSquare.
I did a few POCs to compare clickhouse vs other databases on ContentSquare's use case. One of them was memSQL. Although memSQL was very good, since we don't need to JOIN big datasets or need killer features like fulltext search, clickhouse gave a better perf/cost ratio for us (I don't remember exactly but it was at least twice cheaper).
Re:ClickHouse as an alternative to Elasticsearch for log sto...
by caust1c on Tuesday March 02, 2021 @01:19PM
(#26318460)
When Cloudflare was considering clickhouse, we did estimates on just the hardware cost and it was well over 10x what clickhouse was based on druids given numbers on events processed per compute unit.
Re:ClickHouse as an alternative to Elasticsearch for log sto...
by advaita on Tuesday March 02, 2021 @01:42PM
(#26318769)
Are you saying druid hardware costs were coming out to be 10x of clickhouse hardware costs?
Caveat: English is not my first language so might have missed your point in translation. :)
Re:ClickHouse as an alternative to Elasticsearch for log sto...
by caust1c on Tuesday March 02, 2021 @03:37PM
(#26320294)
That's right, yeah. We would have had to buy 10x the servers in order to support the same workload that clickhouse could.
Re:ClickHouse as an alternative to Elasticsearch for log sto...
by jetter on Tuesday March 02, 2021 @01:01PM
(#26318218)
I've mentioned Pinot and Druid briefly in 2018 writeup:
https://pixeljets.com/blog/clickhouse-as-a-replacement-for-e... (see "Compete with Pinot and Druid" )
But from user's perspective is clickhouse superior to the others?