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