• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 200
  • Last Modified:

MS SQL Server 2008 Clustering

Hi,
I am looking for a details on how MS windows clustering works forSQL server clustering.

What is shared nothing architecture? What is Quorum?

Thanks
0
crazywolf2010
Asked:
crazywolf2010
1 Solution
 
Ryan McCauleyData and Analytics ManagerCommented:
As a general overview, here's my favorite walk-through, which takes you through clustering Windows Server and then clustering SQL Server on top of it, and explains the steps in a reasonable amount of details as it goes along:

http://dbperf.wordpress.com/2010/07/10/walkthrough-cluster-setup-sql-win-2008/

There's also a brief walk-through/explanation on this MSDN blog that gives some more details, though it's not SQL Server specific:

http://blogs.msdn.com/b/clustering/archive/2008/01/18/7151154.aspx

To your specific questions, though:

Shared Nothing: This just means that there's no single component whose failure would cause downtime for a clustered application. For example, in a two node cluster with a quorum drive, a failure of the quorum disk (or the connection to it) would cause a failure of the clustered applications. However, if you add a third node to the cluster, it can fall back to node majority using networking, so you gain some reliability.

What is quorum: Usually this is a physical disk (a LUN on your SAN or a shared disk in your drive cage) that the cluster nodes use to help determine who is in charge of what applications (they also use the network, but the disk exists as a fallback). Clustering Windows Server, at least in the default configuration, requires a Quorum disk. You can switch the cluster model to "node majority", but there are risks involved, especially for smaller clusters.

What are you wanting to learn - how clustering works as a concept, the specific aspects of how clustering impacts SQL Server's operation, or something else?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now