Supported MySQL Topologies
  • 1 Minute to read
  • Dark
    Light
  • PDF

Supported MySQL Topologies

  • Dark
    Light
  • PDF

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.


Enable MySQL Global Transaction Identifiers (GTIDs)

Global Transaction Identifiers (GTIDs) uniquely identify transactions that occur on a server within a cluster. The identifier allows you to easily confirm if master and slave servers are consistent.
In order to enable the GTIDs in MySQL, run the following command in the MySQL console:

gtid_mode=ON;
enforce_gtid_consistency=ON;
show global variables like '%GTID%';




Was this article helpful?