Altinity
ClickHouse Leading Service Provider

Presentations

Posts tagged webinar
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
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
Webinar Slides: Introduction to the Mysteries of ClickHouse Replication

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

Built-in replication is a powerful ClickHouse feature that helps scale data warehouse performance as well as ensure high availability. This webinar will introduce how replication works internally, explain configuration of clusters with replicas, and show you how to set up and manage ZooKeeper, which is necessary for replication to function. We'll finish off by showing useful replication tricks, such as utilizing replication to migrate data between hosts. Join us to become an expert in this important subject!

Read More
Webinar Slides: ClickHouse and the Magic of Materialized Views

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

Materialized views are a killer feature of ClickHouse that can speed up queries 200X or more. Our webinar will teach you how to use this potent tool starting with how to create materialized views and load data. We'll then walk through cookbook examples to solve practical problems like deriving aggregates that outlive base data, answering last point queries, and using AggregateFunctions to handle problems like counting unique values, which is a special ClickHouse feature. There will be time for Q&A at the end. At that point you'll be a wizard of ClickHouse materialized views and able to cast spells of your own.

Read More
Analyzing Billion Row Datasets with ClickHouse

Presented at Percona Live Austin, May 2019 and at the Webinar, June 5, 2019

By Alexander Zaitsev, Altinity CTO and Robert Hodges, Altinity CEO

Columnar stores like ClickHouse enable users to pull insights from big data in seconds, but only if you set things up correctly. This talk will walk through how to implement a data warehouse that contains 1.3 billion rows using the famous NY Yellow Cab ride data. We'll start with basic data implementation including clustering and table definitions, then show how to load efficiently. Next, we'll discuss important features like dictionaries and materialized views, and how they improve query efficiency. We'll end by demonstrating typical queries to illustrate the kind of inferences you can draw rapidly from a well-designed data warehouse. It should be enough to get you started--the next billion rows is up to you!

Read More
Webinar Slides: ClickHouse on Kubernetes!

Slides for the Webinar, presented on April 16, 2019 
For the webinar video visit https://www.altinity.com/webinarspage/2019/3/7/a-fast-intro-to-fast-query-with-clickhouse

Data services are the latest wave of applications to catch the Kubernetes bug. Altinity is pleased to introduce the ClickHouse operator, which makes it easy to run scalable data warehouses on your favorite Kubernetes distro. This webinar shows how to install the operator and bring up a new data warehouse in three simple steps. We also cover storage management, monitoring, making config changes, and other topics that will help you operate your data warehouse successfully on Kubernetes. There is time for demos and Q&A, so bring your questions. See you online!

Read More
Webinar Slides: A Fast Intro to Fast Query with ClickHouse

Slides for the Webinar, presented on March 6, 2019 
For the webinar video visit https://www.altinity.com/webinarspage/2019/3/7/a-fast-intro-to-fast-query-with-clickhouse

Extracting business insight from massive pools of machine-generated data is the central analytic problem of the digital era. ClickHouse data warehouse addresses it with sub-second SQL query response on petabyte-scale data sets. In this talk we'll discuss the features that make ClickHouse increasingly popular, show you how to install it, and teach you enough about how ClickHouse works so you can try it out on real problems of your own. We'll have cool demos (of course) and gladly answer your questions at the end. 

Read More
Supercharge your analytics with ClickHouse

Author: Vadim Tkachenko, CTO at Percona and Principal Advisor at Altinity. Vadim leads Percona Engineering Team, which focuses on development of Percona software products, technology research and performance evaluations of Percona’s and third-party products.

Overview: ClickHouse is a real-time analytical database system. Even though they’re only celebrating one year as open source software, it has already proved itself ready for the serious workloads.

We talk about ClickHouse in general, some internals and why it is so fast. ClickHouse works in conjunction with MySQL -- traditionally weak for analytical workloads -- and this presentation demonstrates how to make the two systems work together.

Read More