Re: RAID or not?

2003-09-02 Thread Michael Loftis
--On Friday, August 22, 2003 8:37 PM -0600 Jim McAtee <[EMAIL PROTECTED]> wrote: I don't quite understand the need to read data before any write. Why wouldn't it just calculate the parity of whatever is being written and just write it to disk? Wouldn't there be slack space, as with any disk s

RE: RAID or not?

2003-09-02 Thread Michael Loftis
--On Friday, August 22, 2003 1:21 PM -0400 "Lefevre, Steven" <[EMAIL PROTECTED]> wrote: "that is not true. mirroring gives you double the read speed and half the write speed. RAID5 gives you less than half the write speed." - OK, I see how it can give you double the read speed, bu

Re: RAID or not?

2003-08-26 Thread Alec . Cawley
> [EMAIL PROTECTED] wrote: > > I do not think it is true that mirroring gives no performance benefit (on a > > well implemented controller). For reads, the raid controller can read > > either copy of the data, so that effectively two reads can be in progress > > at the same time, doubling read

Re: RAID or not?

2003-08-22 Thread Jim McAtee
[EMAIL PROTECTED] wrote: > > I say go with RAID 5, on a controller card. > > > Mirroring just gives you backup, and you lose half your diskspace. It > offers > > no performance benefit, and actually the computer might have to work > harder > > to make sure the drives are in sync. > > I do not thi

RE: RAID or not?

2003-08-22 Thread Lefevre, Steven
-Original Message- From: news [mailto:[EMAIL PROTECTED] Behalf Of Jon Drukman Sent: Thursday, August 21, 2003 9:24 PM To: [EMAIL PROTECTED] Subject: Re: RAID or not? Lefevre, Steven wrote: > I say go with RAID 5, on a controller card. > > Mirroring just gives you backup, and

RE: RAID or not?

2003-08-22 Thread Alec . Cawley
> I say go with RAID 5, on a controller card. > Mirroring just gives you backup, and you lose half your diskspace. It offers > no performance benefit, and actually the computer might have to work harder > to make sure the drives are in sync. I do not think it is true that mirroring gives no per

Re: RAID or not?

2003-08-21 Thread Dan Nelson
In the last episode (Aug 21), Jon Drukman said: > Lefevre, Steven wrote: > >I say go with RAID 5, on a controller card. > > Mirroring just gives you backup, and you lose half your diskspace. > > It offers no performance benefit, and actually the computer might > > have to work harder to make sure t

Re: RAID or not?

2003-08-21 Thread Jon Drukman
Lefevre, Steven wrote: I say go with RAID 5, on a controller card. Mirroring just gives you backup, and you lose half your diskspace. It offers no performance benefit, and actually the computer might have to work harder to make sure the drives are in sync. that is not true. mirroring gives you d

Re: RAID or not?

2003-08-21 Thread Per Andreas Buer
[EMAIL PROTECTED] (Lefevre, Steven) writes: > I say go with RAID 5, on a controller card. > .. > > You get better performance than mirroring or regular drive, because > the data is spread out over your drives. It's not as good as disk > striping, though. Ehh. Wrong. That is not how it works. If y

Re: RAID or not?

2003-08-21 Thread David Griffiths
ROTECTED]> To: "Jackson Miller" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, August 21, 2003 10:20 AM Subject: RE: RAID or not? > I say go with RAID 5, on a controller card. > > Mirroring just gives you backup, and you lose half your diskspace. It offers

RE: RAID or not?

2003-08-21 Thread Lefevre, Steven
lto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 11:56 AM To: Jon Drukman Cc: [EMAIL PROTECTED] Subject: Re: RAID or not? On Thursday 21 August 2003 2:23, Jon Drukman wrote: > if you're mostly running SELECTs then i would recommend a mirrored > configuration. I would say I am runnin

Re: RAID or not?

2003-08-21 Thread Jackson Miller
On Thursday 21 August 2003 2:23, Jon Drukman wrote: > if you're mostly running SELECTs then i would recommend a mirrored > configuration. I would say I am running about %50 SELECTS, 30% UPDATE, 20% INSERT. However I don't know how to find that out for sure. Would that affect how I set up the RA

Re: RAID or not?

2003-08-21 Thread Per Andreas Buer
Jackson, Jackson Miller <[EMAIL PROTECTED]> writes: > I have 4 SCSI drives currently. Well, is you want Redundancy you don't have a choice. Mirror them. 2x 2 drives. You might want to put OS and write-ahead-log on one and InnoDB/MyISAM-data on the other. > I would like to have 1 drive run the

Re: RAID or not?

2003-08-21 Thread Colbey
I like using either raid 0+1.. it really cooks, or if you can'y spare the disks, raid 1 ...Something pushing that many queries, should probably be protected from disk failure. On Wed, 20 Aug 2003, Jackson Miller wrote: > I am setting up a dedicated MySQL server with some pretty heavy usage.

Re: RAID or not?

2003-08-21 Thread Jon Drukman
Jackson Miller wrote: I am setting up a dedicated MySQL server with some pretty heavy usage. I am not much of a sys admin (mostly a programmer). I have some questions about the best drive configuration. I have 4 SCSI drives currently. I would like to have 1 drive run the OS, 1 drive to be th

RAID or not?

2003-08-21 Thread Jackson Miller
I am setting up a dedicated MySQL server with some pretty heavy usage. I am not much of a sys admin (mostly a programmer). I have some questions about the best drive configuration. I have 4 SCSI drives currently. I would like to have 1 drive run the OS, 1 drive to be the MySQL data directory