Welcome to Percona Live Online 2021
Online Open Source Database Conference
Back To Schedule
Thursday, May 13 • 07:00 - 07:30
Hybrid TP/AP With MySQL and ClickHouse

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.

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.

avatar for Stig Bakken

Stig Bakken

Senior Database Architect, Huawei
Stig is a Senior Database Architect at Huawei's Cloud Databases team in Trondheim, Norway. Prior to Huawei Stig has a diverse background in a lot of disciplines including data engineering at TietoEVRY financial services, DevOps/GitOps, mobile apps and cloud infrastructure at Zedge... Read More →

Thursday May 13, 2021 07:00 - 07:30 EDT
Room #3