Supported MySQL Topologies

Rivery 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 (and optionally GTIDs enabled).
In this case, the MySQL connector always connects to and follows this standalone MySQL server instance.

Master and slave

Rivery 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. Generally, this is not a problem except for the multi-master topologies.

Highly-available clusters

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

Note:

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