Change Data Capture

Why Analyze Raw MySQL Query Logs?

Raw MySQL Query Logs

In this blog post, I’ll examine when looking at raw MySQL query logs can be more useful than working with tools that only have summary data.
In my previous blog post, I wrote about analyzing MySQL Slow Query Logs with ClickHouse and ClickTail. One of the follow-up questions I got is when do you […]

Read more

MySQL CDC, Streaming Binary Logs and Asynchronous Triggers

MariaDB ColumnStore

In this post, we’ll look at MySQL CDC, streaming binary logs and asynchronous triggers.
What is Change Data Capture and why do we need it?
Change Data Capture (CDC) tracks data changes (usually close to realtime). In MySQL, the easiest and probably most efficient way to track data changes is to use binary logs. However, other […]

Read more