From: | "Evan D(dot) Hoffman" <evandhoffman(at)gmail(dot)com> |
---|---|
To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
Cc: | David Boreham <david_list(at)boreham(dot)org>, Postgresql Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID |
Date: | 2013-05-10 16:34:36 |
Message-ID: | CABRB-LsG7myVf0N4MNs2RYB+pL=4QBssahU=y8+QR1OUqCpy2w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'd expect to use a RAID controller with either BBU or NVRAM cache to
handle that, and that the server itself would be on UPS for a production
DB. That said, a standby replica DB on conventional disk is definitely a
good idea in any case.
On Fri, May 10, 2013 at 12:25 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> On Fri, May 10, 2013 at 11:11 AM, Evan D. Hoffman
> <evandhoffman(at)gmail(dot)com> wrote:
> > Not sure of your space requirements, but I'd think a RAID 10 of 8x or
> more
> > Samsung 840 Pro 256/512 GB would be the best value. Using a simple
> mirror
> > won't get you the reliability that you want since heavy writing will burn
> > the drives out over time, and if you're writing the exact same content to
> > both drives, they could likely fail at the same time. Regardless of the
> > underlying hardware you should still follow best practices for
> provisioning
> > disks, and raid 10 is the way to go. I don't know what your budget is
> > though. Anyway, mirrored SSD will probably work fine, but I'd avoid
> using
> > just two drives for the reasons above. I'd suggest at least testing
> RAID 5
> > or something else to spread the load around. Personally, I think the
> ideal
> > configuration would be a RAID 10 of at least 8 disks plus 1 hot spare.
> The
> > Samsung 840 Pro 256 GB are frequently $200 on sale at Newegg. YMMV but
> they
> > are amazing drives.
>
> Samsung 840 has no power loss protection and is therefore useless for
> database use IMO unless you don't care about data safety and/or are
> implementing redundancy via some other method (say, by synchronous
> replication).
>
> merlin
>
From | Date | Subject | |
---|---|---|---|
Next Message | Evan D. Hoffman | 2013-05-10 16:36:21 | Re: Re: [GENERAL] pg_upgrade fails, "mismatch of relation OID" - 9.1.9 to 9.2.4 |
Previous Message | Alvaro Herrera | 2013-05-10 16:32:07 | Re: authentication/privileges |