Groups | Blog | Home
all groups > sql server clustering > september 2006 >

sql server clustering : Questions on Mirrored Drives in Clustering Environment


Will
9/20/2006 3:19:40 PM
I haven't used Microsoft (or Veritas) clustering software before, and I
would like to understand better whether certain disk configurations are
allowed, or recommended.

When working with a stand-alone server that is not going to be clustered,
and the storage is mission critical, my normal instinct is to build a disk
configuration on a fibre channel array that does RAID on the drives and
presents a logical volume to the Windows OS over fibre channel. I then
create a duplicate disk topology (separate fibre card, separate fibre
switch, separate fibre array) and then use Windows RAID 1 to mirror between
the two systems. I get the best of both worlds in that the individual
fibre arrays give me hardware fault tolerance, and the software RAID
protects me if one of the fibre arrays fails. I've never lost a volume
doing things this way and I've learned to trust this a lot more than any one
piece of equipment that claims to be "fault tolerant".

Is this a safe configuration for the shared quorum storage in a clustered
environment? It seems to me that getting two computers to share just one
logical volume is plenty difficult enough. If I am going to use Windows
software RAID to replicate that volume and then share the two separate but
synchronized volumes with a cluster host, I can imagine lots of strange
cases where the failover might not be clean at all. Is the configuration I
use for stand-alone hosts even allowed for a cluster? If there are any
guidelines on this I would appreciate seeing them.

--
Will

Russ Kaufmann (MVP)
9/20/2006 7:38:58 PM
[quoted text, click to view]

No. All disks must be basic disks in standard MSCS implementations. This
includes the quorum.


[quoted text, click to view]

Not at all. It is a simple matter of masking the LUNs using the WWN. If your
storage team is not capable of doing this, have them fired and hire somebody
that knows what they are doing.


--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
Denver starting Nov 14th
NYC starting Dec 4th.

Andrew Sword [MVP]
9/21/2006 12:00:00 AM
You may want to look into Veritas Storage Foundation.


[quoted text, click to view]

John Fullbright [MVP]
9/21/2006 12:37:39 PM
If you're going to create the volume on a SAN, that why not use the SAN to
do the Mirroring? When I do designs that require replicated storage, I
leverage the replication technology of the SAN platform I work with
(SnapMirror) In doing this, the replication design for either MSCS or VCS
(with the agent for NetApp SNapMirror) is exactly same and independent of
the clustering technology used. Before going down the route of something
like VVR, which would in essense be dynamic disks, you may want to look at
the MS support for Dynamic Disks in an MSCS environment. If you go VVR/VCS,
I suppose it doesn't much matter on the dynamic disks but you're locked into
one solution set. By leveraging the native replication of the SAN platform,
you keep all of your options open.





[quoted text, click to view]

Brian Desmond [MVP]
9/21/2006 12:59:17 PM
You can do this with Veritas' Storage foundation and either the MSCS option
or VCS, but I wouldn't recommend it in that I think it's just plain
overkill.

--
Thanks,
Brian Desmond
Windows Server MVP - Directory Services

www.briandesmond.com


[quoted text, click to view]

Will
9/21/2006 4:03:38 PM
[quoted text, click to view]

I guess you have never had the experience of EMC doing a firmware upgrade
and then losing the entire array for three days?

Stuff happens. Having options via a fully redundant piece of hardware is
usually not something you usually regret. Getting that redundancy via
Windows software RAID is extremely cheap. Getting that redundancy via
proprietary vendor products, software licenses, and hardware, is extremely
extremely extremely expensive.

Using Windows software RAID for clustering quorum storage however doesn't
appear to be an option.


[quoted text, click to view]

I guess I see it the opposite way. By going with Dynamic disks, I can use
different vendors for storage, and commoditize their products as cheaper
products become available. If I rely on one vendor for all of that
capability, that one vendor holds me hostage and can be very unreasonable in
negotiating additional licenses.

--
Will


John Fullbright [MVP]
9/21/2006 5:30:24 PM
Back in the day, when I was assimilated, I did my share of EMC escallations,
and HP, and Hatachi for that matter. I ROSS'd about 150 times.




[quoted text, click to view]

Linchi Shea
9/23/2006 6:13:01 PM
If you already have an EMC SAN infrastructure in place, I really don't see
any point of doing Windows software RAID.

Linchi

[quoted text, click to view]
AddThis Social Bookmark Button