Take the 2-minute tour ×
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. It's 100% free, no registration required.

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?

Thanks

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 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 at 20:41

1 Answer 1

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

 
discard

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.