December 26, 2007 at 9:46 am
What is the recommended approach for doing an active/active or active/passive configuration for SQL2005? Is the cluster the best option of automatic failover or does database mirroring offer the same capability? Is there such a thing as an active/active configuration where two SQL servers are sharing the load for the same databases and applications?
January 11, 2008 at 11:02 am
MS SQL clustering requires identical hardware and software on two or more servers. The term Active/Active in SQL cluster means multi instance. You could install a SQL instance on each node of your cluster nodes. This also requires separate SQL license for each node. SQL server does not know how to load balance. Each instance has its own resource. Clustering allows the entire instance to failover if problem with the active node.
Database Mirroring is a lot easier to setup and does not require expensive hardware. The servers do not have to be in the same physical location like cluster servers. DB mirroring is per database configuration only.
-GW
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply