Re: SSD + RAID - Mailing list pgsql-performance

From david@lang.hm
Subject Re: SSD + RAID
Date
Msg-id alpine.DEB.2.00.1002231256470.5131@asgard.lang.hm
Whole thread Raw
In response to Re: SSD + RAID  (Aidan Van Dyk <aidan@highrise.ca>)
Responses Re: SSD + RAID  (Mark Mielke <mark@mark.mielke.cc>)
Re: SSD + RAID  (Dave Crooke <dcrooke@gmail.com>)
List pgsql-performance
On Tue, 23 Feb 2010, Aidan Van Dyk wrote:

> * david@lang.hm <david@lang.hm> [100223 15:05]:
>
>> However, one thing that you do not get protection against with software
>> raid is the potential for the writes to hit some drives but not others.
>> If this happens the software raid cannot know what the correct contents
>> of the raid stripe are, and so you could loose everything in that stripe
>> (including contents of other files that are not being modified that
>> happened to be in the wrong place on the array)
>
> That's for stripe-based raid.  Mirror sets like raid-1 should give you
> either the old data, or the new data, both acceptable responses since
> the fsync/barreir hasn't "completed".
>
> Or have I missed another subtle interaction?

one problem is that when the system comes back up and attempts to check
the raid array, it is not going to know which drive has valid data. I
don't know exactly what it does in that situation, but this type of error
in other conditions causes the system to take the array offline.

David Lang

pgsql-performance by date:

Previous
From: Aidan Van Dyk
Date:
Subject: Re: SSD + RAID
Next
From: "Kevin Grittner"
Date:
Subject: Re: moving pg_xlog -- yeah, it's worth it!