Re: Arguments Pro/Contra Software Raid

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Steve Atkins <steve(at)blighty(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>, "Pgsql-Performance ((E-mail))" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Arguments Pro/Contra Software Raid
Date: 2006-05-10 04:50:28
Message-ID: 87zmhqwkiz.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance


Steve Atkins <steve(at)blighty(dot)com> writes:

> On May 9, 2006, at 2:16 AM, Hannes Dorbath wrote:
>
> > Hi,
> >
> > I've just had some discussion with colleagues regarding the usage of
> > hardware or software raid 1/10 for our linux based database servers.
> >
> > I myself can't see much reason to spend $500 on high end controller cards
> > for a simple Raid 1.
> >
> > Any arguments pro or contra would be desirable.

Really most of what's said about software raid vs hardware raid online is just
FUD. Unless you're running BIG servers with so many drives that the raid
controllers are the only feasible way to connect them up anyways, the actual
performance difference will likely be negligible.

The only two things that actually make me pause about software RAID in heavy
production use are:

1) Battery backed cache. That's a huge win for the WAL drives on Postgres.
'nuff said.

2) Not all commodity controllers or IDE drivers can handle failing drives
gracefully. While the software raid might guarantee that you don't actually
lose data, you still might have the machine wedge because of IDE errors on
the bad drive. So as far as runtime, instead of added reliability all
you've really added is another point of failure. On the data integrity
front you'll still be better off.

--
Greg

In response to

Browse pgsql-general by date

  From Date Subject
Next Message PFC 2006-05-10 06:50:22 Re: [PERFORM] Arguments Pro/Contra Software Raid
Previous Message Greg Stark 2006-05-10 04:41:20 Re: Arguments Pro/Contra Software Raid

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-05-10 05:15:11 Re: UNSUBSCRIBE
Previous Message Greg Stark 2006-05-10 04:41:20 Re: Arguments Pro/Contra Software Raid