Loading…
Attending this event?
Welcome to Percona Live Online 2021
Online Open Source Database Conference
REGISTER HERE!
Back To Schedule
Thursday, May 13 • 07:00 - 07:30
Hybrid TP/AP With MySQL and ClickHouse

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Video will become available 10 minutes before session start


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.

Speakers
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
Feedback form isn't open yet.