mkdev2009
asked on
Active Active MS SQL Cluster
Hi All,
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes we've tried merge replication but it's not what we are looking at.
Thanks again for the suggestion :)