How much does Altinity.Cloud cost?

How much does Altinity.Cloud cost?

Altinity.Cloud has a simple, flexible billing model. Learn how billing works and how to tune resources for cost-efficient analytics.

Trip Report: Amsterdam ClickHouse Meetup on 8 June

Trip Report: Amsterdam ClickHouse Meetup on 8 June

The June 8 meetup in Amsterdam was the first in-person ClickHouse community meetup in over 2 years. We bring you the first-hand report of ClickHouse talks, news, and updates.

Tips for High-Performance ClickHouse Clusters with S3 Object Storage

Tips for High-Performance ClickHouse Clusters with S3 Object Storage

ClickHouse often runs in a cluster, and cluster operation poses some interesting questions regarding S3 usage. They include parallelizing data load across nodes, benefits of horizontal vs. vertical scaling, and avoiding unnecessary replication. In this article, we will discuss how ClickHouse clusters can be used with S3 efficiently thanks to two important new features: the ‘s3Cluster‘ table function and zero-copy replication.

MORE secrets of ClickHouse Query Performance

MORE secrets of ClickHouse Query Performance

ClickHouse is famously fast, but a small amount of extra work makes it much faster. Join us for the latest version of our popular talk on single-node ClickHouse performance. We start by examining the system log to see what ClickHouse queries are doing. Then we introduce standard tricks to increase speed: adding CPUs, reducing I/O with filters, restructuring joins, adding indexes, and using materialized views, plus many more. In each case we show how to measure the results of your work. There will as usual be time for questions as well at the end. Watch the replay to polish your ClickHouse performance skills!

Webinar: Adding Fast Analytics to MySQL Applications with ClickHouse

Webinar: Adding Fast Analytics to MySQL Applications with ClickHouse

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, take you through important features like support for MySQL wire protocol and finish with design approaches that allow you to extend MySQL applications with analytics that can handle billions of rows.

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.

Webinar: Secrets of ClickHouse Query Performance

Webinar: Secrets of ClickHouse Query Performance

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. We hope you’ll enjoy the first step to becoming a ClickHouse performance guru!