Hybrid TP/AP With MySQL and ClickHouse

OLAP and OLTP databases provide different trade-offs for database users, but what if you could have the best of both worlds? In this talk, we describe how to use ClickHouse as an OLAP replication slave of MySQL databases, including support for transactional consistency (MVCC- which ClickHouse does not support). The talk will go into how the MaterializeMySQL database engine in ClickHouse works, the modifications we did to support transactional consistency, and the options users will have for choosing between freshness and OLAP performance. Speaker: Stig Bakken – Huawei