X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 88F6BD1CADC for ; Wed, 10 Mar 2004 18:32:21 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 97340-08 for ; Wed, 10 Mar 2004 14:32:18 -0400 (AST) Received: from COLSWEEPER.cranel.com (newmail.cranel.com [66.192.200.227]) by svr1.postgresql.org (Postfix) with ESMTP id 69E24D1BAC8 for ; Wed, 10 Mar 2004 14:32:16 -0400 (AST) Received: from colmail01.cranel.com (colmail01.cranel.com) by COLSWEEPER.cranel.com (Content Technologies SMTPRS 4.3.12) with ESMTP id ; Wed, 10 Mar 2004 13:31:32 -0500 Received: from cranel.com (gspiegelberg.cranel.com [192.168.11.134]) by colmail01.cranel.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id GRDD7PWZ; Wed, 10 Mar 2004 13:36:22 -0500 Message-ID: <404F5F2C.4070505@cranel.com> Date: Wed, 10 Mar 2004 13:32:12 -0500 From: Greg Spiegelberg Organization: Cranel, Inc. User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "scott.marlowe" Cc: Erwin Brandstetter , pgsql-admin@postgresql.org Subject: Re: Hardware for a database server References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/192 X-Sequence-Number: 12761 scott.marlowe wrote: > On Wed, 10 Mar 2004, Erwin Brandstetter wrote: > >>Controller / Hard Discs: >>RAID 5 with 4+ discs including a hot spare. But SCSI or SATA? >>I am undecided on this. Until about a year ago, I would have said SCSI, >>period. But I have read of SATA RAIDs for entry-level-servers doing >>quite well and Linux dealing with it ever more smoothly. > > > Standard IDE drives have an issue that all the ones I've tested so far, > and presumably, most of the rest lie about fsync, and therefore are not > guaranteed to have a coherent database on them should you lose power > during a transaction. If SATA drives in fact have proper fsyncing with > write caching, then they're a great choice. You might want to test one or > two before commiting to a rack of them. I won't debate the issues with standalone/internal ATA type drives... especially with Scott... however most RAID subsystems regardless of the drive technology used are viable options and a SATA RAID subsystem attached via fibre/SAN which has an internal battery backed cache and additional external UPS should not be discounted due to the overall shortcomings of ATA. External RAID subsystems get around the many issues and limitations of internal controllers such as those offered by 3ware, Adaptec and LSI. I believe this to the point where I have recommended and we here are purchasing a Candera system that is SATA connected via fibre and we're a EMC-Hitachi-IBM storage partner/reseller/consulting shop. >>Power supply: >>Secured with UPS, auto-shutdown before power fails, so do I need my >>RAID controller battery-backed still? > > Yep. Power supplies fail, motherboards fry and take out the power rail > every so often. Idiots trip over power cords. hehe. been there, done > that, got the TShirt. Double ditto. -- Greg Spiegelberg Sr. Product Development Engineer Cranel, Incorporated. Phone: 614.318.4314 Fax: 614.431.8388 Email: gspiegelberg@Cranel.com Cranel. Technology. Integrity. Focus.