pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed3 disks configured RAID 0 over 10 disks configured in RAID 5 (self replicating SAN)
6+ messages / 4 participants
[nested] [flat]
* 3 disks configured RAID 0 over 10 disks configured in RAID 5 (self replicating SAN)
@ 2013-08-27 22:33 Rene Romero Benavides <rene.romero.b@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Rene Romero Benavides @ 2013-08-27 22:33 UTC (permalink / raw)
To: pgsql-admin
Thanks for your attention.
What would you choose for a postgresql installation: 3 disks configured
with RAID 0 (in a self replicating SAN) over 10 disks configured with RAID
5 (also in a self replicating SAN) , we have space constraints that
prohibit us from choosing RAID 1+0.
I've been persuaded to choose RAID 5, because writes and parity computation
will be spread over 10 disks compensating write overhead providing a better
level of data security.
Do you think it was a good decision? Any comment will be appreciated. Have
a good day.
--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: 3 disks configured RAID 0 over 10 disks configured in RAID 5 (self replicating SAN)
@ 2013-08-27 23:18 Scott Whitney <scott@journyx.com>
0 siblings, 0 replies; 6+ messages in thread
From: Scott Whitney @ 2013-08-27 23:18 UTC (permalink / raw)
To: Rene Romero Benavides <rene.romero.b@gmail.com>; pgsql-admin
Never RAID 5 for a database. When I say "never," I can give you edge-case scenarios, but you're basically taking a 4x overhead on all writes. Now, RAID-0 is a bad choice as well, since JBOD has no replication, but it sounds like you might have that end under control.
-------- Original message --------
From: Rene Romero Benavides <rene.romero.b@gmail.com>
Date: 08/27/2013 5:35 PM (GMT-06:00)
To: pgsql-admin@postgresql.org
Subject: [ADMIN] 3 disks configured RAID 0 over 10 disks configured in RAID 5 (self replicating SAN)
Thanks for your attention.
What would you choose for a postgresql installation: 3 disks configured with RAID 0 (in a self replicating SAN) over 10 disks configured with RAID 5 (also in a self replicating SAN) , we have space constraints that prohibit us from choosing RAID 1+0.
I've been persuaded to choose RAID 5, because writes and parity computation will be spread over 10 disks compensating write overhead providing a better level of data security.
Do you think it was a good decision? Any comment will be appreciated. Have a good day.
--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: 3 disks configured RAID 0 over 10 disks configured in RAID 5 (self replicating SAN)
@ 2013-08-28 00:47 Scott Marlowe <scott.marlowe@gmail.com>
parent: Rene Romero Benavides <rene.romero.b@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Scott Marlowe @ 2013-08-28 00:47 UTC (permalink / raw)
To: Rene Romero Benavides <rene.romero.b@gmail.com>; +Cc: pgsql-admin
Does your controller support odd number RAID-10 i.e. RAID 1E? If so
then 3 disks in RAID-1E. Or better 10 disks in 1E
On Tue, Aug 27, 2013 at 4:33 PM, Rene Romero Benavides
<rene.romero.b@gmail.com> wrote:
> Thanks for your attention.
> What would you choose for a postgresql installation: 3 disks configured with
> RAID 0 (in a self replicating SAN) over 10 disks configured with RAID 5
> (also in a self replicating SAN) , we have space constraints that prohibit
> us from choosing RAID 1+0.
> I've been persuaded to choose RAID 5, because writes and parity computation
> will be spread over 10 disks compensating write overhead providing a better
> level of data security.
>
> Do you think it was a good decision? Any comment will be appreciated. Have a
> good day.
>
> --
> El genio es 1% inspiración y 99% transpiración.
> Thomas Alva Edison
> http://pglearn.blogspot.mx/
>
--
To understand recursion, one must first understand recursion.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: 3 disks configured RAID 0 over 10 disks configured in RAID 5 (self replicating SAN)
@ 2013-08-28 01:18 Rene Romero Benavides <rene.romero.b@gmail.com>
parent: Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Rene Romero Benavides @ 2013-08-28 01:18 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: pgsql-admin
First of all, thank you so much for your valuable time.
It probably does, though we have a requirement of having available at least
twice the expected database size, and 50% of disk space overhead sounds
like too much for us to take in a replicated SAN environment and a
PostgreSQL master/slave - streaming replication setup.
our options regarding disks availability at the moment are:
a 3 disks array dedicated for PostgreSQL in any RAID configuration we'd
like
OR
a 10 disks array shared with 14 virtual machines running the middleware
layer and the application infrastructure in a RAID 5 configuration
again, I do really appreciate your kindly help.
2013/8/28 Scott Marlowe <scott.marlowe@gmail.com>
> Does your controller support odd number RAID-10 i.e. RAID 1E? If so
> then 3 disks in RAID-1E. Or better 10 disks in 1E
>
> On Tue, Aug 27, 2013 at 4:33 PM, Rene Romero Benavides
> <rene.romero.b@gmail.com> wrote:
> > Thanks for your attention.
> > What would you choose for a postgresql installation: 3 disks configured
> with
> > RAID 0 (in a self replicating SAN) over 10 disks configured with RAID 5
> > (also in a self replicating SAN) , we have space constraints that
> prohibit
> > us from choosing RAID 1+0.
> > I've been persuaded to choose RAID 5, because writes and parity
> computation
> > will be spread over 10 disks compensating write overhead providing a
> better
> > level of data security.
> >
> > Do you think it was a good decision? Any comment will be appreciated.
> Have a
> > good day.
> >
> > --
> > El genio es 1% inspiración y 99% transpiración.
> > Thomas Alva Edison
> > http://pglearn.blogspot.mx/
> >
>
>
>
> --
> To understand recursion, one must first understand recursion.
>
--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: 3 disks configured RAID 0 over 10 disks configured in RAID 5 (self replicating SAN)
@ 2013-08-28 02:24 Scott Marlowe <scott.marlowe@gmail.com>
parent: Rene Romero Benavides <rene.romero.b@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Scott Marlowe @ 2013-08-28 02:24 UTC (permalink / raw)
To: Rene Romero Benavides <rene.romero.b@gmail.com>; +Cc: pgsql-admin
On Tue, Aug 27, 2013 at 7:18 PM, Rene Romero Benavides
<rene.romero.b@gmail.com> wrote:
> First of all, thank you so much for your valuable time.
>
> It probably does, though we have a requirement of having available at least
> twice the expected database size, and 50% of disk space overhead sounds like
> too much for us to take in a replicated SAN environment and a PostgreSQL
> master/slave - streaming replication setup.
>
> our options regarding disks availability at the moment are:
> a 3 disks array dedicated for PostgreSQL in any RAID configuration we'd
> like
> OR
> a 10 disks array shared with 14 virtual machines running the middleware
> layer and the application infrastructure in a RAID 5 configuration
>
> again, I do really appreciate your kindly help.
Whatever you do do NOT put postgresql on a RAID-5 array if you can
help it. Can you steal a few disks for a 4 or 5 disk RAID 1E?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: 3 disks configured RAID 0 over 10 disks configured in RAID 5 (self replicating SAN)
@ 2013-08-28 02:36 Fernando Hevia <fhevia@gmail.com>
parent: Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Fernando Hevia @ 2013-08-28 02:36 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: pgsql-admin; Rene Romero Benavides <rene.romero.b@gmail.com>
In your case I'd go for the 3 disk raid 0 setup.
El ago 27, 2013 11:25 p.m., "Scott Marlowe" <scott.marlowe@gmail.com>
escribió:
>
> On Tue, Aug 27, 2013 at 7:18 PM, Rene Romero Benavides
> <rene.romero.b@gmail.com> wrote:
> > First of all, thank you so much for your valuable time.
> >
> > It probably does, though we have a requirement of having available at
least
> > twice the expected database size, and 50% of disk space overhead sounds
like
> > too much for us to take in a replicated SAN environment and a PostgreSQL
> > master/slave - streaming replication setup.
> >
> > our options regarding disks availability at the moment are:
> > a 3 disks array dedicated for PostgreSQL in any RAID configuration we'd
> > like
> > OR
> > a 10 disks array shared with 14 virtual machines running the middleware
> > layer and the application infrastructure in a RAID 5 configuration
In your case I'd go for the 3 disk raid 0 setup. Be sure to have your
failover scripts tested.
Regards,
Fernando
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2013-08-28 02:36 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-08-27 22:33 3 disks configured RAID 0 over 10 disks configured in RAID 5 (self replicating SAN) Rene Romero Benavides <rene.romero.b@gmail.com>
2013-08-28 00:47 ` Scott Marlowe <scott.marlowe@gmail.com>
2013-08-28 01:18 ` Rene Romero Benavides <rene.romero.b@gmail.com>
2013-08-28 02:24 ` Scott Marlowe <scott.marlowe@gmail.com>
2013-08-28 02:36 ` Fernando Hevia <fhevia@gmail.com>
2013-08-27 23:18 Re: 3 disks configured RAID 0 over 10 disks configured in RAID 5 (self replicating SAN) Scott Whitney <scott@journyx.com>
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