Webinar Slides. Tips and tricks every ClickHouse user should know

By Robert Hodges and Altinity Engineering Team
Slides for the Webinar, presented on Dec 3, 2019 
Webinar recording is available here

New users of ClickHouse love the speed but may run into a few surprises when designing applications. Column storage turns classic SQL design precepts on their heads. This talk shares our favorite tricks for building great applications. We'll talk about fact tables and dimensions, materialized views, codecs, arrays, and skip indexes, to name a few of our favorites. We'll show examples of each and also reserve time to handle questions. Join us to take your next step to ClickHouse guruhood!

Read More
Unified Data Platform

by Pauline Yeung, Cisco Systems
Presented on December ClickHouse Meetup. Dec 3, 2019
Our journey from using ClickHouse in an internal threat library web application, to experimenting with ClickHouse to migrating production data from Elasticsearch, Postgres, HBase, to trying ClickHouse for error metrics in a product under development.

Read More
Clickhouse Capacity Planning for OLAP Workloads

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.

Read More
ClickHouse Query Performance Tips and Tricks

by Robert Hodges, Altinity CEO
Presented at ClickHouse October Meetup, Oct 9, 2019

Read More
Webinar Slides. Adding Fast Analytics to MySQL Applications with Clickhouse

By Robert Hodges and Altinity Engineering Team
Slides for the Webinar, presented on Octo 10, 2019 
Webinar recording is available here

Successful MySQL applications have a very common scale problem: how to provide analytics when data grows too large for MySQL to handle. Fortunately, there is a good answer. ClickHouse is a popular, open source column store you can use to add fast analytics to MySQL applications. We'll start with an introduction to ClickHouse for MySQL users showing familiar SQL syntax and table engine design. We'll then walk through important features like support for MySQL wire protocol, ability to read data directly from MySQL tables, and different ways to move data from MySQL into ClickHouse. Finally, we'll touch on design approaches that allow you to extend MySQL applications with analytics that can handle billions of rows.

Read More
ClickHouse Introduction. Paris Meetup 2019

by Alexander Zaitsev, Altinity CTO
Presented at Paris Meetup, October 3, 2019

Read More
Webinar Slides. Secrets of ClickHouse Query Performance

By Robert Hodges and Altinity Engineering Team
Slides for the Webinars, presented on Sept 11 and Sept 17, 2019 
Webinar recording is available here

ClickHouse is famous for speed. That said, you can almost always make it faster! This webinar uses examples to teach you how to deduce what queries are actually doing by reading the system log and system tables. We'll then explore standard ways to increase query speed: data types and encodings, filtering, join reordering, skip indexes, materialized views, session parameters, to name just a few. In each case we'll circle back to query plans and system metrics to demonstrate changes in ClickHouse behavior that explain the boost in performance. We hope you'll enjoy the first step to becoming a ClickHouse performance guru!

Read More
Webinar Slides. Altinity Cluster Manager: ClickHouse Management for Kubernetes and Cloud

By Robert Hodges and Altinity Engineering Team
Slides for the Webinar, presented on August 21, 2019 
Webinar recording is available here

Simplified management is a prerequisite for running any data warehouse at scale. Altinity is developing a new web-based console for ClickHouse called the Altinity Cluster Manager. It's now in beta and offers simplified operation of ClickHouse installations for users. In this webinar we introduce the ACM and demonstrate use on Kubernetes as well as Amazon Web Services. Attendees are welcome to sign up as beta testers and provide feedback. Please join us to see the future of Clickhouse management!

Read More
Tricks every ClickHouse designer should know

by Robert Hodges, Altinity CEO
Presented at Meetup in Mountain View, August 13, 2019

Read More
How Clickhouse became the default analytics database for Mux

by Adam Brown, Mux founder

Presented at Meetup in Mountain View, August 13, 2019

Read More