CDC Guide for Linux, UNIX, and Windows

10.5
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

MySQL CDC Overview

PowerExchange uses the MySQL binary log reader, mysqlbinlog, to read change events for source tables from the MySQL binary log. PowerExchange then extracts the change records from the real-time change stream or from PowerExchange Logger for Linux, UNIX, and Windows log files and makes the changes available to PowerCenter CDC sessions.

The binary log reader and PowerExchange capture process must run on the same Linux or Windows machine. This machine can be remote from the MySQL source database server.

Use of the PowerExchange Logger is optional. MySQL CDC is certified with Logger instances that run on Linux or Windows.

If you have a MySQL Enterprise Edition source, PowerExchange uses the DataDirect ODBC driver for MySQL to retrieve source metadata from the MySQL database server. This ODBC driver is included in the PowerExchange installation for Linux. If you have a MySQL Community Edition source, you must use the MySQL native ODBC driver. PowerExchange does not supply the native driver.

PowerExchange works with the PowerExchange Client for PowerCenter (PWXPC) to extract change records from the real-time change stream or from the PowerExchange Logger logs and transmit the data to CDC sessions. The CDC sessions can load the data to one or more targets. Use of PowerCenter transformations is optional.

MySQL CDC

Preparing MySQL Sources

Configuring PowerExchange for MySQL CDC

Managing MySQL CDC

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal