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

Your email address will not be published. Required fields are marked *

More Presentations

Conference Slides. Five Great Ways to Lose Data on Kubernetes (And How to Avoid Them)
Conference Slides. Five Great Ways to Lose Data on Kubernetes (And How to Avoid Them)

As databases and stateful apps rapidly adopt Kubernetes, the reality of accidental data loss isn't far behind. Robert Hodges, Altinity CEO, will give listeners tools to push through the paranoia and ensure happy experiences with cloud native data.

Webinar Slides. ClickHouse Unleashed 2020: Our Favorite New Features for Your Analytical Applications

Curious what’s new in ClickHouse? This talk is for you! Watch to learn about new features of ClickHouse, ranging from tiered storage to compact MergeTree format to SQL join improvements. Preview new features like object storage and LDAP support planned for the remainder of 2020. We close out, by discussing Altinity Stable Releases and how they help you decide when features are ready for production use. Don’t miss this opportunity to get current on ClickHouse improvements to help you build even better analytics!

Webinar Slides. Adventures in Observability: How In-House ClickHouse Deployment Enabled Instana to Build Better Monitoring for Users

Instana is an Application Performance Monitoring solution that provides complete visibility into complex distributed systems, including ClickHouse servers. In this webinar, we welcome Marcel Birkner and Yoann Buch of Instana. They describe how the Instana team uses ClickHouse to power their solution, lessons they have learned, and how they integrated them back into Instana's own ClickHouse monitoring features. Along the way, you'll learn how to set up Instana on ClickHouse, what important metrics you should track, how ClickHouse is integrated in end-to-end distributed tracing, and what level of automation is available for root cause analysis and alerting.