What would be an ideal setup for these requirements: -- can read and write data from both data center -- if either data center is lost, the other can take over
The options I can think of : -- say if we have 6 servers, put 3 in one data center, the other 3 at the other center, set up the six servers as one cluster, is latency (nodes exchanging info, internal replication within the cluster) an issue?
--set up one cluster at each data center and have them replicate to each other. But how to set up master master replication though, do you have to do on individual node level?
Thanks!