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

How do I implement a transparent high availability database fail-over solution for my website?

share|improve this question

migrated from Oct 21 '10 at 1:17

This question came from our site for professional and enthusiast programmers.

closed as not a real question by TomTom, Nick Kavadias, sysadmin1138, splattne Oct 21 '10 at 8:33

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

This is entirely database dependent - each vendor does it differently, if at all. Specify a database if you want a useful answer. – Oded Oct 20 '10 at 13:17

The global answer to cover each and every single possible scenario is:


That's about as specific of an answer as you can get without providing at least your operating system and choice of DBMS.

share|improve this answer

You could utilize Amazon's Cloudfront, Load Balancing, and Auto Scaling features with their RDS product.

share|improve this answer

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