From: | "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: databases and RAID ... |
Date: | 2002-05-25 05:14:38 |
Message-ID: | 200205251044.38172.mallah@trade-india.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Rajesh Kumar Mallah. | 2002-05-25 05:16:25 | Re: Talking to port 5432 |
Previous Message | Tom Lane | 2002-05-25 05:02:39 | Re: databases and RAID ... |