Supported MySQL topologies
Data Integration Log-Based Extraction for MySQL supports the following MySQL topologies:
Standalone
When using a single MySQL server, the server must have the _binlog_ enabled. In this case, the MySQL connector always connects to and follows this standalone MySQL server instance.
Primary and replica
Data Integration can follow one of the primary nodes or one of the replicas only (if the replica 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 replicas to keep track of all changes on any of the primary nodes.
For MySQL clusters to run in Data Integration, GTID must be enabled.
