MariaDB Replication Setup between Two Clusters (Primary and DR)

Follow

testjetco

• November 19, 2018 09:50

 I have reviewed the following url:

     https://severalnines.com/blog/architecting-failure-disaster-recovery-mysqlmariadb-galera-cluster

and I want to implement the 'Active Passive Master-Slave Cluster via Async Replication', i.e. two separate clusters running at primary and DR site.  Primary site calls 'Cluster1' while Dr calls 'Cluster2'.  For example, primary node 3 is master while dr node 3 is slave.

Questions:

(1) wsrep_cluster_state_uuid of the two clusters must be the same or can be different?

(2) Must Cluster 2 be started before configuring dr node 3 as slave?

(3) After configuring the master and slave nodes, data from master node will be replicated to slave node.  Will the updated data in slave node be replicated automatically to other non-slave DR nodes (since they all belong to Cluster 2)?

0

• Official comment

  

  Krzysztof Ksiazek

  • November 19, 2018 09:59

  Hi,

  Those two clusters are separate entities therefore wsrep_cluster_state_uuid should be different. Think of it as a two separate nodes (Galera cluster consisting of several nodes can be, to some extend, treated as a single entity) connected via replication. As such, obviously, your DR cluster will have to be started and provisioned using data from the primary site before you can configure the replication. Again, think as two nodes in a replication setup.

  Data replicated to slave node will be replicated to the rest of the cluster assuming you have log slave updates enabled. This should be enough to trigger the galera replication across the DR cluster.

  Comment actions Permalink

Please sign in to leave a comment.