Active Active MS SQL Cluster
Posted on 2014-09-09
Our organization has been mandated with creating a fully redundant solution with a uptime of 99.9%. Although we can have a HA setup for all servers, our main concern is on ensuring the data integrity of the database.
Is there any solution which can allow us to enable a true Active/Active Cluster that allows read/writes to happen to both nodes concurrently? I'm looking at a solution that can be applied to a Production-DR that will allow read/writes to both environments concurrently?
As I know, Microsoft SQL's AlwaysOn allows for Multiple reads but to ensure data integrity, there must be singularity whereby only 1 node is able to write.
Appreciate your kind comments and suggestions!