SQL Server Active/Active, Possible?
Dear all,
I am a newbies in SQL server. One of my client what to using Clustering and SAN Feature to make his SQL server have high avaliabilty. However, since they want to utilize the SQL server, they would like to active/active cluster with network load balancing. However, questions comes:
1. Can I mount a same database in a Active/Active Cluster environment?
2. If I can do that, how will the SQL server handle those instance/how can I set it up?
3. When there have two users using difference node SQL server to insert data, what will happen?
Please help.
Thanks and Regards
Jacky
You cannot have multiple physical machines connect to the same database for updates.
Under certain conditions you can connect multiple machines to the same read-only database for reporting solutions, but update is not allowed.
Probably your best bet would be to have each node have its own database, and use merge replication to aggregate the updates.
SQL Server's implementation of clustering is not a RAC-like solution. It is not a load balanced/scale out solution, nor can you load balance a write-based SQL Server.
You can load balance read-only SQL Servers, and there are different ways to achieve that.
As Kevin says, if you need to have two physical servers accessing the same data for write purposes, you can then use a technology like replication to keep the databases sync'd up.
