Re: Linux LVM software raid, and SAN question.

On Tue, 22 Jan 2008 15:30:05 -0800 (PST), Kyle Schmitt
<kyleaschmitt@xxxxxxxxx> wrote:

In the beefy enterprise-level linux database installs, the ones where
you need massive redundancy supplied by two SAN devices, what is the
current ideal for setting them up?

Software raid to mirror the luns from both sans, and use static
partitions?
Software raid, then LVM ontop of it?
LVM to mirror and handle the whole damned thing?
PowerPath for multipathing, or using the multipathing the kernel
provides?

The particular instance I'm dealing with is a database server that
will have two HBAs, each connected to a different SAN, which is
mirrored from the linux side. While there are several ways I know how
to set it up, I'm unsure as to which will really be the best way (not
necessarily easiest) to do it.

Thanks
--Kyle


Someone posted the inherent flaws in your statement about beefy and
such so I'll skip that (but they're right you know...).

What you're asking about is two fabrics. One hba goes to a switch
which goes to a storage port on the array. The other hba goes to a
different switch and a storage port on the same array as the other
switch.
Nothing ties these two switches together.

This is fairly common practice when availability is a top priority.

Forget LVM based raid, it's almost pointless when the hardware based
raid is in the array (I assume you have an array though you do not
state that explicitly).
However make sure the LVM is in place. Such things make backend
migrations much simpler.

Do not cross the streams Ray....
Do not create any connection betwee the two fabrics. This allows for
independent maintenance to each fabric with zero impact on the
application.

As for multi-pathing, I thought MPIO was suported on Linux. If so,
use it. It works well and is free. Avoid PowerPath like the plague.
I'm not even sure they sell it anymore. I think Hitachi has EOL'd
their version of pay-for multipathing as well.

Hmm, perhaps I'm missing a piece here. Are you asking about having
two completely seperate SANs and not just fabrics? So two arrays as
well? If so, that's less common but not unheard of.
Same practice applies only you would use LVM to mirror. Or at least I
would.

~F
.

Relevant Pages

  • Re: RAID Advice
    ... Using software RAID provided by Windows only allows you to ... space would still be available after you create the mirror. ... can't get it to accept it as a valid array. ... Partition the server to a more managable size, ...
    (microsoft.public.windows.server.general)
  • Re: software RAID 1 mirror details?
    ... > set up a software RAID 1 mirror under Fedora on two ... > identical SATA drives using the installation tools. ... Just create first the software RAID partitions you like with the size ...
    (Fedora)
  • Re: Linux LVM software raid, and SAN question.
    ... you need massive redundancy supplied by two SAN devices, ... Software raid to mirror the luns from both sans, ... LVM to mirror and handle the whole damned thing? ... mirrored from the linux side. ...
    (comp.arch.storage)
  • RE: software RAID 1 mirror details?
    ... software RAID 1 mirror details? ... identical SATA drives using the installation tools. ... installer to create identical sized partitions on ...
    (Fedora)
  • Re: Transaction log
    ... That's what log backups are for. ... SAN so you have DR. ... > How could we mirror local disk with remote disk/disk on SAN? ... >> Wayne Snyder, MCDBA, SQL Server MVP ...
    (microsoft.public.sqlserver.server)