pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
3 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