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

If I was in your situation I would put both 18's into a sw raid 1
configuration.  You may lose some speed on the writes since it's doing more
work than writing to 1 disk but the redundancy will be well worth it should
the day come when you need it.

-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Rajesh Kumar
Mallah.
Sent: Friday, May 24, 2002 10:15 PM
To: pgsql-admin
Subject: Re: [ADMIN] databases and RAID ...



Hi Fred,

I have only two hardisks and no HW card.
how can i utilize them best?

i do not want to loose data one fine day
discovering one  my SCSI havaing DB
has failed.    :-(

should i run database on only 1 18GB scsi and
pg_dump every 6 hrs my critical tables
on other machine (which has not database and has 2*18GB SCSI
in RAID 1) ?
or
should i go for SW RAID 1 configuration putting 2 hardrives
in the DB server.

ok , in worst case i will try both the configs and post the
benchmarks  ;-)

thanks everyone for their time.


regds
mallah.


On Saturday 25 May 2002 10:16 am, Fred Moyer wrote:
> use raid 10 (striping with mirroring) if you have more than 2 hard
> disks.  much faster than raid 1.
>
> > Hi
> >
> > 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.
> >
> >
> > thanks
> >
> >
> > regds
> > mallah.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > --
> > Rajesh Kumar Mallah,
> > Project Manager (Development)
> > Infocom Network Limited, New Delhi
> > phone: +91(11)6152172 (221) (L) ,9811255597 (M)
> >
> > Visit http://www.trade-india.com ,
> > India's Leading B2B eMarketplace.
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster