Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: David Boreham <david_list(at)boreham(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server
Date: 2011-10-25 14:55:02
Message-ID: CAGTBQpbqKtn49KzV0GKOvJ63bjv9s+fg1J6Mfs1AyFZncunrEg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Oct 24, 2011 at 11:37 PM, David Boreham <david_list(at)boreham(dot)org> wrote:
>> What about redundancy?
>>
>> How do you swap an about-to-die SSD?
>>
>> Software RAID-1?
>
> The approach we take is that we use 710 series devices which have predicted
> reliability similar to all the other components in the machine, therefore
> the unit of replacement is the entire machine. We don't use trays for
> example (which saves quite a bit on data center space). If I were running
> short endurance devices such as 320 series I would be interested in
> replacing the drives before the machine itself is likely to fail, but I'd do
> so by migrating the data and load to another machine for the replacement to
> be done offline. Note that there are other operations procedures that need
> to be done and can not be done without downtime (e.g. OS upgrade), so some
> kind of plan to deliver service while a single machine is down for a while
> will be needed regardless of the storage device situation.

Interesting.

But what about unexpected failures. Faulty electronics, stuff like that?

I really don't think a production server can work without at least raid-1.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message David Boreham 2011-10-25 15:00:38 Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server
Previous Message alan 2011-10-25 14:12:55 how to use explain analyze