Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. 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 need to design and implement a highly available SQL Server 2012 clustering on Amazon AWS. In the white paper presented by Amazon, they provided an example of Active/ Passive SQL Cluster. Do you know whether Active/ Active is also possible?


share|improve this question
Active/Active refers to essentially two clusters running over two nodes. Since cloud services are just standard machines like the ones you might run in your own datacenter, you should be able to run active/active. Having said that, I would look at running an Availability Group instead of just clustering. – Max Vernon Jan 16 '14 at 2:26
Please clarify what you mean by "Active/Active". For standard SQL/Windows failover clustering, this terminology is a misnomer. You can certainly set up clustering using AWS, you just have to design it properly. – Mike Fal Jan 21 '14 at 20:41
@Abiete : are you want to "loophole" environment or Hyper-V environment. – Md Haidar Ali Khan Feb 11 '15 at 12:43

Active/Active denotes two live datastores that can be simultaneously accessed by the application(s) in question. SQL Server does not have a solution for this, including AlwaysOn Availability Groups, which at best will only provide you with additional readable replicas. Outside of Oracle RAC, there isn't a solution for this.

share|improve this answer

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.