We are evaluating different database cluster solutions. We would like to get information on some of situations.
We have 2 sites with cluster each running 3 nodes as master-master.
Synchronous replication is configured between clusters. So all the nodes in both clusters remains in sync.
There are multiple applications running on both sites and uses their site cluster continuously. Meaning that continuous read/write is perform.
When one node reboots in one of the cluster, what would be the order of operations, data sync → replication or replication → data sync ?
When network connectivity of one of the node of the cluster is lost, when network connectivity is restored, will data sync happen correctly ?
As replication is configured in both clusters and they replicate to each other, is there any chance of getting stuck in indefinite replication ?
I mean cluster1 replicates to cluster2 and cluster2 replicates to cluster1.
In case link between cluster goes down for days, when link is restored, will the data sync happened correctly ?
In case one of the node goes into split-brain, will it be recovered correctly ?