From: Steve Crawford <scrawford@pinpointresearch.com>
To: Wes Vaske (wvaske) <wvaske@micron.com>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: New server: SSD/RAID recommendations?
Date: Mon, 06 Jul 2015 09:56:18 -0700
Message-ID: <559AB332.50304@pinpointresearch.com> (raw)
In-Reply-To: <31701C89A44B714FB8D242F806E7286C5AED32FA@NTXBOIMBX01.micron.com>
References: <CAFwQ8rfwyBMD7AiL659qtG+UhsOUZthLSBYF7ODTn6TKxJoTPg@mail.gmail.com>
<VisenaEmail.44.70ed435cef1739b1.14e4c07dd3d@tc7-visena>
<31701C89A44B714FB8D242F806E7286C5AED32FA@NTXBOIMBX01.micron.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
On 07/02/2015 07:01 AM, Wes Vaske (wvaske) wrote:
>
> What about a RAID controller? Are RAID controllers even available for
> PCI-Express SSD drives, or do we have to stick with SATA if we need a
> battery-backed RAID controller? Or is software RAID sufficient for SSD
> drives?
>
> Quite a few of the benefits of using a hardware RAID controller are
> irrelevant when using modern SSDs. The great random write performance
> of the drives means the cache on the controller is less useful and the
> drives you’re considering (Intel’s enterprise grade) will have full
> power protection for inflight data.
>
For what it's worth, in my most recent iteration I decided to go with
the Intel Enterprise NVMe drives and no RAID. My reasoning was thus:
1. Modern SSDs are so fast that even if you had an infinitely fast RAID
card you would still be severely constrained by the limits of SAS/SATA.
To get the full speed advantages you have to connect directly into the bus.
2. We don't typically have redundant electronic components in our
servers. Sure, we have dual power supplies and dual NICs (though
generally to handle external failures) and ECC-RAM but no hot-backup CPU
or redundant RAM banks and...no backup RAID card. Intel Enterprise SSD
already have power-fail protection so I don't need a RAID card to give
me BBU. Given the MTBF of good enterprise SSD I'm left to wonder if
placing a RAID card in front merely adds a new point of failure and
scheduled-downtime-inducing hands-on maintenance (I'm looking at you,
RAID backup battery).
3. I'm streaming to an entire redundant server and doing regular backups
anyway so I'm covered for availability and recovery should the SSD (or
anything else in the server) fail.
BTW, here's an article worth reading:
https://blog.algolia.com/when-solid-state-drives-are-not-that-solid/
Cheers,
Steve
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: scrawford@pinpointresearch.com, wvaske@micron.com
Subject: Re: New server: SSD/RAID recommendations?
In-Reply-To: <559AB332.50304@pinpointresearch.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox