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
crazywolf2010Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan McCauleyEnterprise 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.