Clickhouse Capacity Planning for OLAP Workloads

By Altinity Team on December 3rd, 2019

Clickhouse Capacity Planning for OLAP Workloads

Altinity Team ClickHouseMeetup

 

by Mik Kocikowski, CloudFlare
Presented on December ClickHouse Meetup. Dec 3, 2019

Concrete findings and “best practices” from building a cluster sized for 150 analytic queries per second on 100TB of http logs. Topics covered: hardware, clients (http vs native), partitioning, indexing, SELECT vs INSERT performance, replication, sharding, quotas, and benchmarking.

 

Leave a Reply

More Presentations

Webinar Slides. Big Data and Beautiful Video: How ClickHouse enables Mux to Deliver Content at Scale

By Adam Brown and Robert Hodges Slides for the Webinar, presented on June 23, 2020 Webinar recording is available here Mux.com enables content providers to stream video to vast audiences while maintaining pin-point control over performance. Join us as Adam Brown, a co-founder of Mux and video expert, explains the role that ClickHouse plays in content delivery. We'll start with an overview of the Mux platform and the importance of real-time feedback. We'll then discuss key features of ClickHouse that enable it to ingest live session data and provide real-time dashboards to Mux users. Finally, we'll talk a bit about the Mux journey to ClickHouse and lessons learned along the way about how data enables content delivery networks.