From: Greg Stark <gsstark@mit.edu>
To: Steve Atkins <steve@blighty.com>
Cc: PostgreSQL General <pgsql-general@postgresql.org>
Cc: Pgsql-Performance ((E-mail)) <pgsql-performance@postgresql.org>
Subject: Re: Arguments Pro/Contra Software Raid
Date: 10 May 2006 00:50:28 -0400
Message-ID: <87zmhqwkiz.fsf@stark.xeocode.com> (raw)
In-Reply-To: <473FC220-A52C-4954-81E9-A14ED33164C2@blighty.com>
References: <e3pmkc$12mk$1@news.hub.org>
<473FC220-A52C-4954-81E9-A14ED33164C2@blighty.com>
Steve Atkins <steve@blighty.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gsstark@mit.edu, steve@blighty.com, pgsql-general@postgresql.org
Subject: Re: Arguments Pro/Contra Software Raid
In-Reply-To: <87zmhqwkiz.fsf@stark.xeocode.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox