[THIN] Re: Slightly OT: SQL Redundancy

If one of your failover situations requires restoring from backup, then
that's not a very high level of redundancy.  I wouldn't consider it to
be high availability, and only "half" of failover.

Drives are going to be the most common thing to fail in a heavy use
server.  The processor, power supplies, and mainboard doesn't get the
type of mechanical abuse HDD's do.
 
 

________________________________

From: thin-bounce@xxxxxxxxxxxxx [mailto:thin-bounce@xxxxxxxxxxxxx] On
Behalf Of Bray, Donovan (ESC)
Sent: Tuesday, August 16, 2005 2:18 PM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: Slightly OT: SQL Redundancy


Put "EMC/Legato's FullTime AutoStart/SE (formerly Co-StandbyServer
AAdvanced)" on your list to check out.
 
I have it on the way to replace our MSCS Exchange Cluster.
 
The advantage of Autostart is that we can use block level mirroring
between nodes and eleminate the single point of failure of the shared
scsi resource.
 
We opted not to use clustering for our SQL boxes due to the steep
processor licensing as you have to graduate to  Enterprise processor
licenses.
 
What we opted to do is buy two hardware boxes that are totally
identical, Each loaded with 2gb RAM (Max for Standard), we licensed the
ACTIVE box for its Dual Processors. We use the spare box just as a
test/development box. Both boxes are configured with two 146gb ultra3
hot-swap scsi drives in a hardware mirror.  24gb system partition, the
rest is for SQL on a secondary partition. If there is a failure on the
primary server, I have dedicated hardware already in the rack, powered
on, ready to recieve the drives  from the failed box.  If the failed
box's drives are whats suspect, then I have to restore from backup.  
 
Your business realities may be different and not allow you to have this
kind of manual failover. But the alternative in our case was just too
expensive to justify.

________________________________

From: Joe Shonk [mailto:joe.shonk@xxxxxxxxx] 
Sent: Tuesday, August 16, 2005 8:55 AM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Slightly OT: SQL Redundancy



Hello,

 

What a success (or failure) has the group encountered in making SQL
servers Highly Available?  Either through clustering (Microsoft or
third-party) or replicated partners.  We are looking to move the Citrix
DataStore and a few application databases to a HA solution, while
minimizing the impact to farm in event an HA partner goes down.

 

Joe

Other related posts: