Re: RAID and Cluster!!

That's not an upgrade, it is a reconfiguration. They do completely
different things. By RAID 1+0 do you mean a stripe of mirrors or a mirror
of stripes?

In either case, the answer is, I don't know. RAID5 gives particular levels
of redundancy while incurring a performance impact for certain types of I/O
patterns. A mirror of stripes gives equivalent redundancy to RAID5 without
having quite a much of a performance impact on certain types of I/O
patterns. A stripe of mirrors gives much greater redundancy than the other
two and generally better performance as well. But, if you are saturating
the I/O channel or stuffing all of your data on a tiny subset of the drives
in the SAN, it really isn't going to matter very much. The recommendations
also vary depending upon whether you have an access pattern that looks like
"tradional OLTP", "traditional DW", or a mix of the two.

Regardless of the performance characteristics, neither one is going to be
more stable than the other in your case. If the SAN drives disconnect, it
doesn't matter if it is a cluster or a standalone SQL Server, it isn't going
to like it. You have to fix the errors on your SAN that are causing the
disconnects first. If those aren't fixed, there isn't anything you are
going to be able to do to make the system stable.

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

"Vai2000" <nospam@xxxxxxxxxxxxx> wrote in message
news:%23Lb1UxbIGHA.524@xxxxxxxxxxxxxxxxxxxxxxx
> Hi All, Want to seek advice and experience from all of you. What is the
> recommended RAID Solution for SQL Cluster on SAN, is it RAID 1+0 or
> RAID-5?
> We just upgraded from RAID 1+0 to RAID 5 and since then we are getting
> hiccups on the Cluster. If there is any connectivity failures on the
> Drives
> (which are recovered after few mins) the Cluster goes haywire and becomes
> unavailable (for e.g. it fails to read off the Quorum Log etc...)
>
>
> Thanks in adv.
>
>


.

Relevant Pages

  • How to RAID1+0 with Solaris 9 SVM
    ... I first tried building 14 mirrors, each made up of two partitions, one ... SVM said, no no, cannot build stripe out of metadevices! ... Solaris Volume Manager supports both RAID 1+0 (which is like having ...
    (SunManagers)
  • Re: IBM FastT vs. EMC Clarion
    ... To my mind raid 10 is Mirror the disks across pairs then stripe the ... mirrors the entire stripe onto the other half of the physical disks. ...
    (AIX-L)
  • Re: FreeBSD Preferred RAID controllers
    ... you first create mirrored pairs of drives, then you stripe across all ... However imagine a RAID ... of your N mirrors is degraded, ...
    (freebsd-questions)
  • Re: FreeBSD Preferred RAID controllers
    ... Subject: FreeBSD Preferred RAID controllers ... drives into two equal pools, create a stripe across all the ... of your N mirrors is degraded, ...
    (freebsd-questions)
  • Re: New PCI IDE controller or new mainboard - advice needed
    ... Currently '\Program Files' is a junction that points to a folder on a RAID ... Installing to stripe will also allow windows to start faster and all I/O ... When I purchased the two new IDE disks 2 months ago, ...
    (microsoft.public.windowsxp.hardware)