From: Greg Spiegelberg <gspiegelberg@cranel.com>
To: scott.marlowe <scott.marlowe@ihs.com>
Cc: Erwin Brandstetter <a9006241@unet.univie.ac.at>
Cc: pgsql-admin@postgresql.org
Subject: Re: Hardware for a database server
Date: Wed, 10 Mar 2004 13:32:12 -0500
Message-ID: <404F5F2C.4070505@cranel.com> (raw)
In-Reply-To: <Pine.LNX.4.33.0403100954270.10418-100000@css120.ihs.com>
References: <Pine.LNX.4.33.0403100954270.10418-100000@css120.ihs.com>
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.
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: gspiegelberg@cranel.com, scott.marlowe@ihs.com, a9006241@unet.univie.ac.at
Subject: Re: Hardware for a database server
In-Reply-To: <404F5F2C.4070505@cranel.com>
References: <Pine.LNX.4.33.0403100954270.10418-100000@css120.ihs.com> <404F5F2C.4070505@cranel.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