Skip to main content
FOSDEM PWA

Replicating Transactional Databases to ClickHouse : Transaction Log Analysis and Time Travel

UB2.252A (Lameere) | Day 1 | 14:00 - 14:20 | Speakers: Arnaud Adant

Replicating Transactional Databases to ClickHouse : Transaction Log Analysis and Time Travel
A picture of a devroom at FOSDEM 2024
Open in browser

Notes

Abstract

This talk discusses the design choices behind this open source project leveraging Debezium : https://github.com/Altinity/clickhouse-sink-connector It reliably replicates data to ClickHouse, a well known open source real time analytics database that can be deployed anywhere. The sink-connector provides an alternative to proprietary solutions that typically lock people in or are only available on the cloud. It works with MySQL, MariaDB. Postgres, Oracle (experimental) and MongoDB. As a bonus, Binary logs analysis and Time Travel will also be presented.

Attachments

Speakers

Arnaud Adant

Arnaud has over 20 years of database experience. He started his career as a software engineer, became more interested in database technology and joined Oracle MySQL in 2011 as a support technical engineer. He is now Database Team Lead at Jump Trading in Chicago, Illinois. When not on a database issue, he likes to play ping pong and read ancient Chinese texts. He is the author of Huaying, a Chinese dictionary iOS app.

Notice: The placeholder video image is licensed under CC BY-SA 4.0. The original image can be found hereChanges made to the image are: Cropped the image to a new ratio, part of the image was cut off.