Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 7489AB5DBCA for ; Mon, 24 Oct 2011 23:37:20 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 21190-04 for ; Tue, 25 Oct 2011 02:37:14 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from mail.nuevasync.com (server13-scl.nuevasync.com [64.13.157.153]) by mail.postgresql.org (Postfix) with ESMTP id 77C31B5DBC8 for ; Mon, 24 Oct 2011 23:37:14 -0300 (ADT) Received: from [69.145.82.235] (unknown [69.145.82.235]) by mail.nuevasync.com (Postfix) with ESMTP id 22D072B19E8 for ; Mon, 24 Oct 2011 20:11:27 -0600 (MDT) Message-ID: <4EA620D1.5090008@boreham.org> Date: Mon, 24 Oct 2011 20:37:05 -0600 From: David Boreham User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server References: <4EA5980E.9050903@boreham.org> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201110/199 X-Sequence-Number: 45421 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.