The issue for infinite loop is due to enabling log slave updates on both nodes node 3 of cluster 1 and node 1 of cluster 2.disabling of log slave updates on node 1 of cluster 2 will resolve the infinite loop issue.
disabling of log slave updates on node 1 of cluster 2 have following issues: (replication between node 3 of cluster 1(master) and node 1 of cluster 2 (master))
- any changes made from node 3 of cluster 1 will reflect to node 1 of cluster 2, but not to remaining nodes in cluster 2
2.any changes made from any nodes other than node 1 in cluster 2 will not reflect to any of the nodes in cluster 1
we will see consistent data on all nodes in both clusters, only if changes are made from node1 in cluster 2
without enabling log slave updates on both nodes we can’t achieve consistent data on all nodes on other hand it will cause infinite loop issue.
master-master replication from one node in cluster 1 and other node in cluster 2 is not possible.
Please let me if there are any other suggestions/recommendations.