Re: databases and RAID ...

From: Andy Ruhl <acruhl(at)SDF(dot)LONESTAR(dot)ORG>
To: "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: databases and RAID ...
Date: 2002-05-25 20:00:45
Message-ID: Pine.NEB.4.44.0205251946410.27727-100000@otaku.freeshell.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, 24 May 2002, 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.
> could anyone give me some pointer , or suggest me
> if its advisable to use RAID 1 with database servers.

Hi Mallah. Sorry I'm so delayed in responding to this.

Before you consider raid because the data is critical, I'd suggest you
come up with a disaster recovery scenario first. Raid is good, but it's a
false sense of security. Raid is meant to protect media failures, and only
media failures. There are many other types of failures that you should
consider before media failures.

Sorry to preach, but I do this as a day job so I can't help it
sometimes...

Software raid will slow down performance, but if performance isn't a
problem, then it's OK. I use NetBSD which has a program called raidframe
that apparently works pretty well. I haven't had time to set it up yet.
FreeBSD uses vinum, and Linux has a new volume management system that
looks pretty slick as well. I don't remember what it's called.

If performance is an issue, buy a hardware raid controller, and use scsi.
It's expensive, but so is data.

Andy

--
acruhl(at)sdf(dot)lonestar(dot)org
SDF Public Access UNIX System - http://sdf.lonestar.org

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ragnar Kjørstad 2002-05-25 20:01:19 Re: databases and RAID ...
Previous Message Fred Moyer 2002-05-25 19:45:12 Re: databases and RAID ...