Solved

Failover Clustering

Posted on 2005-05-17
2
625 Views
Last Modified: 2013-11-15
Our organization needs a more fault-tolerant configuration of SQL Server than just running it
on its on a RAID-5 server.  We lost our RAID system over the weekend (something about
the parity stripe getting lost).

I've read a little about M$ failover clustering.  It sounds great, but my question is,
how well does it work?  I have seen some pretty lame software from M$, even
though SQL Server is awesome.  

Any first-hand experiences would be incredibly much-appreciated.

Thanks.
-Dan
0
Comment
Question by:Danimal
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 23

Assisted Solution

by:adathelad
adathelad earned 25 total points
ID: 14018651
Hi Danimal,

We used Clustering at my last place of work. I personally did not implement it and I don't have any experience of setting it up etc. BUT I do know it worked a treat for us.

There is effectively a "heartbeat" connection between the nodes - if a node fails, this "heartbeat" gets broken and the backup node kicks in to take over. A number of tests were carried out whereby the primary node was deliberately "knocked out" and every time the failover clustering did it's job.

I would have no qualms about recommending it.

HTH
0
 
LVL 21

Accepted Solution

by:
Kevin3NF earned 25 total points
ID: 14018699
It works extremely well when set up correctly.  It is also very expensive.  The O/S needs to be Enterprise level, and SQL Server Enterprise list price from Microsoft is $20K per processor.  In an active/passive configuration with both nodes being only 2 way, this is $40K just for the SQL software.  Add in the O/S and a cluster hardware package from a vendor....

I supported Clustering at Microsoft SQL Server support for 6 months and was amazed at some of the customer names I saw that had 2 and 4 node clusters set up and how robust they were.

Alternative solution:
http://www.nsisoftware.com/pro/doubletake/

I have not used them but the presentation  made me want to test it at the very leasy.  I am not affiliated with the company in any way.
0

Featured Post

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question