Solved

Failover Clustering

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

VM backup deduplication is a method of reducing the amount of storage space needed to save VM backups. In most organizations, VMs contain many duplicate copies of data, such as VMs deployed from the same template, VMs with the same OS, or VMs that h…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
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.

828 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