Clustering - Active / Active nodes -- sql server clustering

Alistair Wong
4/17/2005 7:27:01 PM

I do not have any experience with MS SQL. I'm a hardware engineer. I focus
mainly on the servers hardware and connectivity.

I was wondering, is it possible to cluster 2 (or more) nodes running all
nodes on active / active as a single MS SQL database system? The servers are
connecting to a common shared storage system.

Is this possible? This is more of a scale out strategy.

Rodney R. Fournier [MVP]
4/17/2005 9:40:59 PM

I am sorry to tell you that is not. A database will only run on one machine
at a time. Clustering will not help you with this problem.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog

[quoted text, click to view]

sql server clustering : Clustering - Active / Active nodes