Hello Friends,
We have to maintain out application at two different locations at two different points across the country. Both of these sites will have their own appservers and DBs. The clients will be directed to their closest site and similarly the appservers should connect to the DBs on their site and not cross-site to avoid network latency. The DBs have to asynchronously replicate with each other. I was wondering if MySQL Cluster Carrier Grade Edition would be solution.