Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space ML1 and version 9.2

Types of Replication

This page describes ClustrixDB replication, which uses a single stream to write and read binlogs. ClustrixDB also supports parallel replication, which is more performant and can be used to replicate to/from ClustrixDB only. 

ClustrixDB supports the MySQL's replication protocol as both a Slave and a Master. It extends the functionality of MySQL by supporting the creation of multiple Slave instances that can connect to distinct replication Masters to consolidate servers.  

  • ClustrixDB supports replication to/from MariaDB 10.3 with no special configuration.
  • ClustrixDB supports replication to/from MySQL 5.7 with GTID mode disabled

Supported Topologies

Here is a sampling of the topologies for replication supported by ClustrixDB:

ClustrixDB can serve as a Master or a Slave to MariaDB 10.4, MySQL 5.7, or ClustrixDB:

Image Added

ClustrixDB also supports slaving from multiple distinct binlogs (consolidation) and Master-Master replication:

Image Added

ClustrixDB also supports the creation of multiple binary logs (binlogs), each of which can correspond to specific databases and can be accessed by distinct replication Slaves.When  When running multiple-Slave configurations, ClustrixDB takes advantage of each node by load-balancing replication connections in a round-robin fashion. For assistance in determining the best topology for your application or whether a specific topology is supported, contact Clustrix Support. 

Caveats for Replication:

  • ClustrixDB does not support GTIDs
  • ClustrixDB does not support ring replication topologies

See also section on Replication concerns when performing Online Schema Changes.

Warning

To ensure correct matching of Master and Slave data when replicating between ClustrixDB and a MySQL instance, set both DBMS' to the same time zone. If time zones differ, you risk mismatched data.

The following topics explain how to configure the cluster for replication, including replication to and from MySQL databases.

Children Display

See also section on Replication concerns when performing Online Schema Changes.ClustrixDB replication:

Children Display