Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server - Mailing list pgsql-performance

From David Boreham
Subject Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server
Date
Msg-id 4EA620D1.5090008@boreham.org
Whole thread Raw
In response to Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server  (Claudio Freire <klaussfreire@gmail.com>)
Responses Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server  (Claudio Freire <klaussfreire@gmail.com>)
List pgsql-performance
On 10/24/2011 4:47 PM, Claudio Freire 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.





pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter
Next
From: Venkat Balaji
Date:
Subject: Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter