speaking
Webinars: Secrets of ClickHouse Query Performance. September 11 or 17
September 11 or 17 , 2019
with Robert HodgesClickHouse 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!
This topic is so important, that we decided to do this webinar twice! Read more to pick your time.
Percona Live Europe, Amsterdam
We are thrilled to be among Percona Live speakers and sponsors once again! Come and meet our team at the Exhibit Hall
Use a special discount code SPaltinity20 to get 20% off registration
Read more about upcoming ClickHouse presentations
ClickHouse Paris Meetup – 2019
Join us to learn about ClickHouse data warehouse and share experience with local ClickHouse users. We will have presentations from Altinity, Yandex development team, and ClickHouse users and contributors: ContentSquare and InfoVista.
REGISTER HERE
ClickHouse October Meetup
Join us for October Meetup in San Francisco.
"A Modern Database on a Modern Orchestration Platform" - Alan Braithwaite of Segment.io will talk about running ClickHouse smoothly on Kubernetes."ClickHouse Performance Tricks" - Robert Hodges of Altinity.com will share some useful tricks on how to make ClickHouse work even faster.
Webinar: Adding Fast Analytics to MySQL Applications with ClickHouse
October 10 , 2019
with Robert Hodges
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.
Watch here
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!
ClickHouse December Meetup
Join us for the December ClickHouse meetup in San Francisco. We'll be meeting at the Cisco OpenLate meetup location.
Register here
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!
San Diego Cloud Native Computing Meetup: Data Warehouses on Kubernetes! A gentle intro to the ClickHouse Operator
Rober Hodges, Altinity CEO introducing ClickHouse Operator for Kubernetes. Meet us in San Diego
ClickHouse February Meetup
Join us for the February ClickHouse meetup in San Francisco. We'll be meeting at the Cloudflare headquarter
Register here
Webinar: ClickHouse Materialized Views. The Magic Continues
February 26, 2020
with Robert Hodges
Materialized views are the killer feature of ClickHouse, and the Altinity 2019 webinar on how they work was very popular. Join this updated webinar to learn how to use materialized views to speed up queries hundreds of times. We'll cover basic design, last point queries, using TTLs to drop source data, counting unique values, and other useful tricks. Finally, we'll cover recent improvements that make materialized views more useful than ever. See you there!
Webinar: ClickHouse Monitoring 101: What to monitor and how
April 1, 202
with Robert Hodges and Ned McClain
You are about to deploy ClickHouse into production. Congratulations! But what about monitoring? In this webinar we will introduce how to track the health of individual ClickHouse nodes as well as clusters. We'll describe available monitoring data, how to collect and store measurements, and graphical display using Grafana. We'll demo techniques and share sample Grafana dashboards that you can use for your own clusters.