Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a website, I want to host on two diffident very far deployments. I have a rather good connection between them. But the users have a good connection only to what's near them.

My Idea is to duplicate the database servers, but I need complete consistency between them, I.E. a transaction should be considered complete only after committed on both machines.

How can I achieve this? any ideas will be appreciated, clustering, replication, etc.

share|improve this question

Your idea already makes no sense to start with, unless ou have TWO websites, not one (i.e. two domains). DNS will not care about where your sites are, so users will get distributed randomly. And with your setup you do NOT have the possibility to rediret them (which would require an AS and then the use of an Anycast architecture).

As a result, half the users go to the wrong server. End of game.

But the users have a good connection only to what's near them.

How do you know. This is internet. Often major countries are easier to be reached than the small one in the neighborhood.

If you HAVE to do it, forget clustering. Go with replication. Painfull to develop, but your only choice. I see this more an excercise in wasting time, though, as you dont have the means to even make sure users go to the correct server.

share|improve this answer
because its an internal enterprise site, i can easily give different address, or different DNS configs.... – Hellfrost Mar 24 '11 at 12:59
Still wont solve the sql server problem, sadly. Replication is the only active/active scenario supported and it requires special programming. – TomTom Mar 25 '11 at 6:09
Im pretty sure you're wrong... – Hellfrost Mar 30 '11 at 8:14

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.