Solved

Failover Clustering

Posted on 2005-05-17
2
609 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
2 Comments
 
LVL 23

Assisted Solution

by:adathelad
adathelad earned 25 total points
Comment Utility
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
Comment Utility
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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
MS SQL export CSV & schedule It 9 40
Windows Server Backup Issues 23 97
separate column 24 19
Sql query 34 16
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now