pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: William Yu <wyu@talisys.com>
To: Iain <iain@mst.co.jp>
Cc: pgsql-admin@postgresql.org
Subject: Re: Tyan Thunder MB for postgres server
Date: Wed, 15 Dec 2004 23:14:03 -0800
Message-ID: <41C135BB.3030702@talisys.com> (raw)
In-Reply-To: <007201c4e315$9074f960$7201a8c0@mst1x5r347kymb>
References: <021a01c4e0dc$774d0620$7201a8c0@mst1x5r347kymb>
	<41BDB10A.6000200@did-it.com>
	<00bf01c4e17c$db69e100$7201a8c0@mst1x5r347kymb>
	<1103038201.22049.14.camel@state.g2switchworks.com>
	<000b01c4e24a$43deaae0$7201a8c0@mst1x5r347kymb>
	<41BFB085.6010102@talisys.com>
	<004501c4e268$acbadca0$7201a8c0@mst1x5r347kymb>
	<cpqhgb$2bun$1@news.hub.org>
	<007201c4e315$9074f960$7201a8c0@mst1x5r347kymb>

Iain wrote:
> Hi William,
> 
>> SOmething to think about. Let's suppose a channel/cable completely 
>> dies. How would you protect against it? Split a logical mirror device 
>> over 2 channels.
> 
> 
> This effectively implements RAID 0+1, right? RAID 1 (mirroring) over 
> RAID 0 striped volumes. I can certainly see your point regarding the 
> redundancy of the controller channels, but my understanding is that 
> (apart from that) RAID 0+1 is less robust that RAID 10 regarding disk 
> failures. Presuming that the system will continue to operate even in the 
> event of 1 channel failure, it's still not a clear choice. Does that 
> seem like a reasonable assessment?

I'm not sure why people say one is better than the other. Both will 
survive the loss of 2 drives -- they're just different drives.

RAID 0+1: A(1m1) s B(1m1) <-- any drive on A and any drive on B
RAID 10:  A(1s1) m B(1s1) <-- both drives on A or both drives on B

Either way, I think you can do both across 2 channels to be redundant 
for a channel/cable failing.

RAID 0+1: C1-m-C2 s C1-m-C2
RAID 10:  C1-s-C1 m C2-s-C2


>> Another trick I've started doing with my MegaRAID setups is mirroring 
>> in hardware but striping in software.
> 
> 
> Yeah, that is a good point. I havn't decided either way but I consider 
> that a viable option.

You can probably do the same hardware + software trick for RAID10. 
Except after OS crashes, Linux+Solaris spends quite a bit of time 
resyncing mirrors and it looks like the MegaRAID controller is a bit 
smarter in knowing when to resync.


> If you were building this system now, and want the option of buying the 
> same disks in 3 years time, do you think it would be a bad idea to go 
> for the ~40GB size? Maybe the next size up would be better, though we 
> don't actually need the extra space.

Always get more space than you need if you can afford it because it's a 
pain in the ass adding more disk space. Especially on the boot drives.


> Also, someone asked me what happens if one of the CPUs fails on this 
> system, will the system continue to operate on 1 CPU. I havn't really 
> considered this, and have never read anything either way, so my 
> assumption is "no, it won't". Any comment?

Doing a google search for "hot swap cpu", I see they've added something 
into Linux but you'd still need hardware support.



view thread (16+ messages)  latest in thread

Message-ID: <41C135BB.3030702@talisys.com>
Permalink:  ../41C135BB.3030702@talisys.com/
Also on:    postgresql.org/message-id/41C135BB.3030702@talisys.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: wyu@talisys.com, iain@mst.co.jp
  Subject: Re: Tyan Thunder MB for postgres server
  In-Reply-To: <41C135BB.3030702@talisys.com>
  References: <021a01c4e0dc$774d0620$7201a8c0@mst1x5r347kymb> <41BDB10A.6000200@did-it.com> <00bf01c4e17c$db69e100$7201a8c0@mst1x5r347kymb> <1103038201.22049.14.camel@state.g2switchworks.com> <000b01c4e24a$43deaae0$7201a8c0@mst1x5r347kymb> <41BFB085.6010102@talisys.com> <004501c4e268$acbadca0$7201a8c0@mst1x5r347kymb> <cpqhgb$2bun$1@news.hub.org> <007201c4e315$9074f960$7201a8c0@mst1x5r347kymb> <41C135BB.3030702@talisys.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