Skip site navigation (1) Skip section navigation (2)

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

From: David Boreham <david_list(at)boreham(dot)org>
To: 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 02:37:05
Message-ID: 4EA620D1.5090008@boreham.org (view raw or flat)
Thread:
Lists: 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.





In response to

Responses

pgsql-performance by date

Next:From: Venkat BalajiDate: 2011-10-25 05:00:10
Subject: Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter
Previous:From: Robert HaasDate: 2011-10-25 02:17:39
Subject: Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group