Hi Hitesh,
I am fine with Hub to hub replication but there should be an automated failover to other available node in different data center who can become a HUB. Do you see any issues with it?
The problem I am facing due to this is:
if I have only 2 nodes in one data center which is used by an application who is only responsible for write operation but have 24 nodes in a different data center which is used by different applications who only want to read the data from these 24 nodes ( Application is divided into 12 sites and have a logical grouping of 2 ldap nodes for isolation purpose).
If I want to use Multi-write replication, the write master in Data center 1 has to send replication request to every single node which makes the list very huge ( for e.g. 3 write data centers i.e. 6 nodes and 24 read nodes = 30 nodes).
Whereas if I could create an additional replication cluster having two nodes doing the job of HUB and replicating data with these 24 read nodes.
At present if HUB node is down, write data center can not automatically failover to other node to treat it as HUB.
If you know of any alternatives through CA configurations, would like to hear from you.
Thanks.