Re: 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(at)postgresql(dot)org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)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.