Clustering with share nothing -- sql server clustering

Greg Hayes
7/15/2004 5:07:54 PM

Hello,

We're are in the basic design process for a cluster. We have some confusion
as to whether SQL Server clustering supports a share nothing scenario - that
is where the clustered machines have their own storage and do not share
storage.

We're trying to find out if this is supported, and if it is, what are the
downsides to this approach versus using a shared storage device.

Any help or comments greatly appreciated.

Thank you,

Greg Hayes

Rodney R. Fournier [MVP]
7/15/2004 6:34:46 PM

Funny you should use that term. Microsoft uses the shared nothing model,
only it means that the controlling node does not share with any other
node(s). One node owns a resource at a time.

You can get what you need from Majority Node Set (MNS) read all about it
here:

http://www.microsoft.com/windowsserver2003/techinfo/overview/clustergeo.mspx

or view an excellent webcast here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;838612

lastly Tech Net has some great information here:

http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/clustering/majnode.mspx

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

[quoted text, click to view]

sql server clustering : Clustering with share nothing