4 ms·

ClickHouse is incredible. It has also replaced a large, expensive and slow Elasticsearch cluster at Contentsquare. We are actually starting an internal team to

ClickHouse is incredible. It has also replaced a large, expensive and slow Elasticsearch cluster at Contentsquare. We are actually starting an internal team to improve it and upstream patches, email me if interested!

wikibob 6y ago
Can you share some more details? How many nodes on both? How much data ingested and stored? What’s the query load?
- AurimasJLT 6y ago
  https://github.com/ClickHouse/clickhouse-presentations/blob/master/meetup30/contentsquare.pdf https://github.com/ClickHouse/clickhouse-presentations/blob/... and the presentation itself https://www.youtube.com/watch?v=lwYSYMwpJOU https://www.youtube.com/watch?v=lwYSYMwpJOU 300Elastic nodes vs 12ClickHouse nodes / 260TB/ lots of querries
jetter 6y ago
Yep, do you guys have a writeup on this? Altinity actually mention Contentsquare case in their video, here: https://www.youtube.com/watch?t=2479&v=pZkKsfr8n3M&feature=youtu.be https://www.youtube.com/watch?t=2479&v=pZkKsfr8n3M&feature=y...
- polote 6y ago
  I'm not sure there is a public writeup. I know that the incredibly talented guy who created the first CH setup at CS planned to write a more global post about data analytics at scale, but after 2 years I still wait for it
  - sylvinus 6y ago
    I'll remind him about the post ;)
  - mgachka 6y ago
    I stopped answering to people about the release date of my next blog post because I'm always postponing it ;-). But don't worry Paul, the day I'll release it you'll be one of the first to be informed.
- mgachka 6y ago
  Hi I'm of the guy who did the 2 presentations of Clickhouse at ContentSquare. There are no blog posts on the migration from ES to CH. But you can find the slides of the 2018 presentation here https://www.slideshare.net/VianneyFOUCAULT/clickhouse-meetupcontentsquare-contentsquare-rex https://www.slideshare.net/VianneyFOUCAULT/clickhouse-meetup... And the slides of the 2019 presentation here https://www.slideshare.net/VianneyFOUCAULT/meetup-a-successful-migration-from-elastic-search-to-clickhouse-179072416 https://www.slideshare.net/VianneyFOUCAULT/meetup-a-successf... There is also a video recording of the 2019 presentation available here. https://www.youtube.com/watch?v=lwYSYMwpJOU https://www.youtube.com/watch?v=lwYSYMwpJOU nb: The video is not great because the camera is often losing focus but it's still understandable.
hodgesrm 6y ago
Your 2019 talk on this was great. I cited it above. Here's a link to slides to supplement others elsewhere in the thread: https://www.slideshare.net/VianneyFOUCAULT/meetup-a-successful-migration-from-elastic-search-to-clickhouse-179072416 https://www.slideshare.net/VianneyFOUCAULT/meetup-a-successf...

wikibob 6y ago

Can you share some more details? How many nodes on both? How much data ingested and stored? What’s the query load?

AurimasJLT 6y ago
https://github.com/ClickHouse/clickhouse-presentations/blob/master/meetup30/contentsquare.pdf https://github.com/ClickHouse/clickhouse-presentations/blob/... and the presentation itself https://www.youtube.com/watch?v=lwYSYMwpJOU https://www.youtube.com/watch?v=lwYSYMwpJOU 300Elastic nodes vs 12ClickHouse nodes / 260TB/ lots of querries

jetter 6y ago

Yep, do you guys have a writeup on this? Altinity actually mention Contentsquare case in their video, here: https://www.youtube.com/watch?t=2479&v=pZkKsfr8n3M&feature=youtu.be https://www.youtube.com/watch?t=2479&v=pZkKsfr8n3M&feature=y...

polote 6y ago
I'm not sure there is a public writeup. I know that the incredibly talented guy who created the first CH setup at CS planned to write a more global post about data analytics at scale, but after 2 years I still wait for it
- sylvinus 6y ago
  I'll remind him about the post ;)
- mgachka 6y ago
  I stopped answering to people about the release date of my next blog post because I'm always postponing it ;-). But don't worry Paul, the day I'll release it you'll be one of the first to be informed.
mgachka 6y ago
Hi I'm of the guy who did the 2 presentations of Clickhouse at ContentSquare. There are no blog posts on the migration from ES to CH. But you can find the slides of the 2018 presentation here https://www.slideshare.net/VianneyFOUCAULT/clickhouse-meetupcontentsquare-contentsquare-rex https://www.slideshare.net/VianneyFOUCAULT/clickhouse-meetup... And the slides of the 2019 presentation here https://www.slideshare.net/VianneyFOUCAULT/meetup-a-successful-migration-from-elastic-search-to-clickhouse-179072416 https://www.slideshare.net/VianneyFOUCAULT/meetup-a-successf... There is also a video recording of the 2019 presentation available here. https://www.youtube.com/watch?v=lwYSYMwpJOU https://www.youtube.com/watch?v=lwYSYMwpJOU nb: The video is not great because the camera is often losing focus but it's still understandable.

hodgesrm 6y ago

Your 2019 talk on this was great. I cited it above. Here's a link to slides to supplement others elsewhere in the thread: https://www.slideshare.net/VianneyFOUCAULT/meetup-a-successful-migration-from-elastic-search-to-clickhouse-179072416 https://www.slideshare.net/VianneyFOUCAULT/meetup-a-successf...