Solved

Failover Clustering

Posted on 2005-05-17
2
615 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
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
Viewers will learn how the fundamental information of how to create a table.

815 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