tips and tricks
Webinar: Tips and tricks every ClickHouse user should know
December 3 , 2019
with Robert Hodges
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!
Webinar: Fast Insight from Fast Data: Integrating ClickHouse and Apache Kafka
January 21, 2020
with Robert Hodges
Apache Kafka is a popular way to load large data volumes quickly to ClickHouse. In this webinar we will cover best practices for integrating Kafka and ClickHouse including setup of Kafka clusters, defining materialized views to pull data into ClickHouse, and organization of target tables. We will also cover alternatives like writing your own connector applications. Altinity is now the community maintainer for ClickHouse Kafka. Our lead Kafka engineer Mikhail Filimonov will be in the webinar to share the latest tips for successful Kafka use. Please join us and bring your questions!
All about JSON and ClickHouse: Tips, tricks, and new features!
JSON is the king of data formats and ClickHouse has a plethora of features to handle it. This webinar covers JSON features from A to Z starting with traditional ways to load and represent JSON data in ClickHouse. Next, we'll jump into the JSON data type: how it works, how to query data from it,...
ClickHouse® Disaster Recovery: Tips and Tricks to Avoid Trouble in Paradise
ClickHouse usually works like a charm, but what if a real disaster strikes?
This webinar introduces popular ways to protect your ClickHouse cluster and maybe your job, too.
Our talk starts with the main patterns for setting up ClickHouse disaster recovery and shows available techniques like cross-region replication, backups, and parallel clusters. We'll cover a fully worked example of DR and also discuss obvious and non-obvious trade-offs.
Every site is a little different--this webinar will provide you the tools to implement a DR strategy that works for you.
Amping up Real-Time Query on Data Lakes with ClickHouse® and Antalya Swarms
Project Antalya enables cheap, real-time ClickHouse query on low-cost data lake storage.
In this webinar we'll go deep on swarms, self-registering, stateless ClickHouse servers that boost query performance up to 50 times. We'll cover swarm setup, cache configuration, and how to monitor performance. We'll then introduce two ways to set up swarm-enabled ClickHouse: on your own Kubernetes clusters and using Altinity.Cloud. Along the way you'll see tricks to save costs, such as using spot instances and swarm scale-up/scale-down to save money. Want to save money *and* go faster? This webinar is for you.