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.
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:
ClustrixDB also supports slaving from multiple distinct binlogs (consolidation) and Master-Master replication:
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.
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 |
---|