Unanswered: Geographically distributed MySQL Servers
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.
Just curious but what is the difference in response times between using one location and the other? How many queries are expecting per day? Is the application used just within your company or is it open to the public? Are these users all based in India?