X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 87AA33B5A90 for ; Thu, 16 Dec 2004 02:17:14 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26483-06 for ; Thu, 16 Dec 2004 02:17:00 +0000 (GMT) Received: from millenium.mst.co.jp (unknown [210.230.185.241]) by svr1.postgresql.org (Postfix) with ESMTP id 8C1F83B5A9A for ; Thu, 16 Dec 2004 02:17:02 +0000 (GMT) Received: from mst1x5r347kymb (lc12114 [192.168.1.114]) by millenium.mst.co.jp (8.11.6p2/3.7W) with SMTP id iBG2GjZ02367; Thu, 16 Dec 2004 11:16:45 +0900 Message-ID: <007201c4e315$9074f960$7201a8c0@mst1x5r347kymb> From: "Iain" To: "William Yu" , 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> Subject: Re: Tyan Thunder MB for postgres server Date: Thu, 16 Dec 2004 11:18:37 +0900 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/149 X-Sequence-Number: 15735 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? > 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. 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. If you have any specific recommendations (for or against) specific drives/manufacturers, please let me know. 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? Thanks again Iain