Re: [ADMIN] databases and RAID ...

2002-05-30 Thread Manuel Sugawara
"Chad R. Larson" <[EMAIL PROTECTED]> writes: > At 01:31 PM 5/26/02 , Manuel Sugawara wrote: > >-RAID (5+0) A logical volume with several RAID 3 logical member > >drives. > > Perhaps a typo? Yes :-( Regards, Manuel. ---(end of broadcast)--- TIP 1

Re: [ADMIN] databases and RAID ...

2002-05-30 Thread Chad R. Larson
At 01:31 PM 5/26/02 , Manuel Sugawara wrote: >-RAID (5+0) A logical volume with several RAID 3 logical member >drives. Perhaps a typo? We built what we called a "plaid", in which we built RAID 5 arrays on Sun A3500 (hardware RAID with cache) [think horizontal] and then striped across the RAID

Re: [ADMIN] databases and RAID ...

2002-05-28 Thread Dmitry Morozovsky
On Fri, 24 May 2002, Kris Deugau wrote: [snip] KD> Note that if you're looking for a system you can hotswap, you will KD> probably need to go SCSI in any case; I'm not aware of any KD> hotswap-capable IDE RAID systems. Not exactly ;-) Promise TX2 and TX4 with special enclosures do the trick.

Re: [ADMIN] databases and RAID ...

2002-05-27 Thread Sander Steffann
> On Sun, May 26, 2002 at 08:00:50AM -0700, Bill Cunningham wrote: > > No Raid 10 is Raid 1 + 0 its strong points are faster writes but slower > > reads. > > RAID 10 reads will actually be faster than RAID 5, but it will require > more disks. (2n instead of n+1). There also seems to be a combinat

Re: [ADMIN] databases and RAID ...

2002-05-26 Thread Manuel Sugawara
Peter Eisentraut <[EMAIL PROTECTED]> writes: > There are also other levels. One poster talked about RAID 10 which > appears to be a mirrored RAID 5. Those are multi-level RAID systems: - RAID (0+1) RAID 1 (high availability) plus RAID 0 (enhaced I/O performace through striping). - RAID (3+0)

Re: [ADMIN] databases and RAID ...

2002-05-26 Thread Ragnar Kjørstad
On Sun, May 26, 2002 at 08:00:50AM -0700, Bill Cunningham wrote: > No Raid 10 is Raid 1 + 0 its strong points are faster writes but slower > reads. RAID 10 reads will actually be faster than RAID 5, but it will require more disks. (2n instead of n+1). -- Ragnar Kjorstad Big Storage -

Re: [ADMIN] databases and RAID ...

2002-05-26 Thread Bill Cunningham
Peter Eisentraut wrote: >Tom Lane writes: > > > >>Is there any rhyme or reason to the various "RAID n" designations? >>Or were they just invented on the spur of the moment? >> >> > >The paper that introduced the term RAID used a numerical classification >for the various schemes. (So I gues

Re: [ADMIN] databases and RAID ...

2002-05-25 Thread Ragnar Kjørstad
On Sat, May 25, 2002 at 12:45:12PM -0700, Fred Moyer wrote: > Performance (fastest->slowest) > hardware raid -> software raid > raid 0 -> 10 -> 1 -> 5 > Redundancy (most -> least) > hardware raid -> software raid > 10, 1 -> 5 -> 0 It's really not possible to compare RAID-l

Re: [ADMIN] databases and RAID ...

2002-05-25 Thread Andy Ruhl
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 a

Re: [ADMIN] databases and RAID ...

2002-05-25 Thread Fred Moyer
JBOD : just a bunch of disks, not raid in my opinion Raid 0 : striping over disks, no redundancy, hence the Redundancy in Redundant Arrays of Independent Disks is zero. Raid 1 : Mirroring, full redundancy, Redundancy 1(00%) Raid 4: see thread Raid 5: see thread,Striping across multiple disks wi

Re: [ADMIN] databases and RAID ...

2002-05-25 Thread Ragnar Kjørstad
On Sat, May 25, 2002 at 09:29:01PM +0200, Peter Eisentraut wrote: > 0 Nonredundant > 1 Mirrored > 2 Memory-style ECC > 3 Bit-interleaved parity > 4 Block-interleaved parity > 5 Block-interleaved distributed parity > [Hennessy & Patterson] > > There are also other levels. One poster talked

Re: [ADMIN] databases and RAID ...

2002-05-25 Thread Peter Eisentraut
Tom Lane writes: > Is there any rhyme or reason to the various "RAID n" designations? > Or were they just invented on the spur of the moment? The paper that introduced the term RAID used a numerical classification for the various schemes. (So I guess the answer is yes.) The traditional levels

Re: [ADMIN] databases and RAID ...

2002-05-25 Thread Fred Moyer
om: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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 disco

Re: [ADMIN] databases and RAID ...

2002-05-25 Thread Karl DeBisschop
On Fri, 2002-05-24 at 15:58, Kris Deugau wrote: > "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. > > If it's that critic

Re: [ADMIN] databases and RAID ...

2002-05-24 Thread Rajesh Kumar Mallah.
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

Re: [ADMIN] databases and RAID ...

2002-05-24 Thread Tom Lane
"Fred Moyer" <[EMAIL PROTECTED]>(by way of Rajesh Kumar Mallah. <[EMAIL PROTECTED]>) writes: > use raid 10 (striping with mirroring) if you have more than 2 hard > disks. much faster than raid 1. Is there any rhyme or reason to the various "RAID n" designations? Or were they just invented on th

Re: [ADMIN] databases and RAID ...

2002-05-24 Thread Fred Moyer
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. >

Re: [ADMIN] databases and RAID ...

2002-05-24 Thread Corey W. Gibbs
, but i would definitly look into a hardware raid controller if you could. hope thishelps corey -Original Message- From: Rajesh Kumar Mallah. [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 5:55 AM To: [EMAIL PROTECTED] Subject:[ADMIN] databases and RAID ... Hi I am se

Re: [ADMIN] databases and RAID ...

2002-05-24 Thread Egon Reetz
I would use hardware RAID level 1 for performance reasons. Egon "Rajesh Kumar Mallah." wrote: > 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. > > cou

Re: [ADMIN] databases and RAID ...

2002-05-24 Thread Kris Deugau
"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. If it's that critical, you would be wise to go buy a hardware RAID controller. >

Re: [ADMIN] databases and RAID ...

2002-05-24 Thread Jeremy Buchmann
Rajesh Kumar Mallah. wrote: > 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

[ADMIN] databases and RAID ...

2002-05-24 Thread Rajesh Kumar Mallah.
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