Re: databases and RAID ... - Mailing list pgsql-admin

From Kris Deugau
Subject Re: databases and RAID ...
Date
Msg-id 3CEE9B4E.8129C7B2@webhart.net
Whole thread Raw
In response to databases and RAID ...  ("Rajesh Kumar Mallah." <mallah@trade-india.com>)
Responses Re: databases and RAID ...
Re: databases and RAID ...
List pgsql-admin
"Rajesh Kumar Mallah." wrote:
> I am setting up a new database server.
> the data is critical that is why i am thniking
> to mirror the SCSI disks in RAID 1 configuration.
> I do not have a hardware raid controller.

If it's that critical, you would be wise to go buy a hardware RAID
controller.

> could anyone give me some pointer , or suggest me
> if its advisable to use RAID 1 with database servers.

Probably not a bad idea, with hardware;  the controller should be able
to stream the data across both disks without slowing down writes.
Software-based RAID may show slower performance as it must process the
command streams for *both* disks in the OS instead of offloading that
task to the controller... although if the disks are SCSI with a decent
SCSI card that should be minimal.

Note that if you're looking for a system you can hotswap, you will
probably need to go SCSI in any case;  I'm not aware of any
hotswap-capable IDE RAID systems.

-kgd
--
Money is overrated.

pgsql-admin by date:

Previous
From: Jeremy Buchmann
Date:
Subject: Re: databases and RAID ...
Next
From: Hal Lynch
Date:
Subject: Talking to port 5432