Skip to main content
Feedback

Supported MySQL topologies

Data Integration Log-Based Extraction for MySQL supports the following MySQL topologies:

Standalone

When a single MySQL server is used, the server must have the _binlog_ enabled. In this case, the MySQL connector always connects to and follows this standalone MySQL server instance.

Master and slave

Data Integration can follow one of the masters or one of the slaves only (if the slave has its binlog enabled), but the connector only sees changes in the cluster that are visible to that server.

Highly-available clusters

A variety of high-availability solutions exist for MySQL, and they make it far easier to tolerate and immediately recover from problems and failures. Most highly available MySQL clusters use GTIDs, letting slaves to keep track of all changes on any of the masters.

note

For MySQL clusters to run in Data Integration, GTID must be enabled.

On this Page