Showing entries 1 to 3
Displaying posts with tag: CDC (reset)
MySQL CDC, Streaming Binary Logs and Asynchronous Triggers

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 approaches exist. For example:

  • General log or Audit Log Plugin (which logs all queries, not just the changes)
  • MySQL triggers (not recommended, as it can slow down the application — more below)

One of the first implementations of CDC for …

[Read more]
MySQL Applier For Hadoop: Real time data export from MySQL to HDFS
MySQL Applier For Hadoop: Implementation
Showing entries 1 to 3