From: | "Fred Moyer" <fred(at)digicamp(dot)com> |
---|---|
To: | "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com>, "pgsql-admin" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: databases and RAID ... |
Date: | 2002-05-25 19:24:30 |
Message-ID: | ILEMKFGEMKDJNPOGGNCKCEAJDCAA.fred@digicamp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)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(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.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2002-05-25 19:29:01 | Re: databases and RAID ... |
Previous Message | Denilson Guedes Duarte | 2002-05-25 12:53:39 | Problems in query |