Let us say I've two server nodes in one data center DC1 and two more server nodes in another data center DC2. Two data centers have some network delay.
Now I'm using SQL select statements on caches which are replicated. Now those caches' write synchronization mode is FULL_SYNC.
Now at a time we have working clients nodes only in one DC but not both. Let's say we have two clients in DC1.
So total nodes is 6 (2 client nodes and 2 server nodes in DC1 and 2 server nodes in DC2).
Our use case is such a way that..
- 2 clients should query only 2 server nodes in DC1 and not the other 2 servers in DC2.
- All the cache queries should be in FULL_SYNC with 2 server nodes in DC1 and DC1-DC2 should be done in ASYNC mode.
- A doubt I got which is, if in client's node discoveryspi, if I (X,Y) ip list as server nodes ips, would the queries always reach X,Y even though the entire topology contains X,Y,Z as server nodes?
Please someone provide us the solution for this.
Note: I saw one GridGain's capability for cluster-cluster replication but that comes under paid version. I am looking for a solution in the community edition.