Re: w/c RAID on a SQL box

2000-11-19 Thread Russell Coker
On 2000-11-16 10:19, Santiago Palmier Campos wrote: >As Rod said, RAID 1 is a mirroring solution and RAID 5 can be called >something like "stripping with data recovery" ;) > >But what you must consider is... > RAID 1 is faster for _reading_ data (as it uses only 1 disk for >read) RAID-1 is

Re: w/c RAID on a SQL box

2000-11-16 Thread Robert Davies
> Raid 1 is faster than a single drive for reads, but about the same for > writes. To get more speed, use raid 0+1, striping plus mirroring. That > wastes a lot of disk, but is faster than level 5 for writes. Keep in > mind, RAID 1 is only mirroring using two disks (typical). > > Raid 5 is slow

Re: w/c RAID on a SQL box

2000-11-16 Thread Kevin Blackham
data storage, obviously with > a good backup policy ;o) but I don't know if it's possible at your hosting > company :o? > > Best regards > Santy > > -Original Message- > From: R. W. Rodolico [mailto:[EMAIL PROTECTED]] > Sent: jueves, 16 de noviembre de 200

RE: w/c RAID on a SQL box

2000-11-16 Thread Santiago Palmier Campos
& RAID 1 for data storage, obviously with a good backup policy ;o) but I don't know if it's possible at your hosting company :o? Best regards Santy -Original Message- From: R. W. Rodolico [mailto:[EMAIL PROTECTED]] Sent: jueves, 16 de noviembre de 2000 4:47 To: [EM

Re: w/c RAID on a SQL box

2000-11-15 Thread R. W. Rodolico
RAID 5. Easy to set up, fast, and reliable. Uses more disks, however. RAID 1 is, I believe, mirroring. With that, all info must be written to two different disks. With RAID 5, the disks are "striped" (not really, but I don't remember the real name for it) and part of each byte, with a checksum, g

w/c RAID on a SQL box

2000-11-15 Thread t s a d i
hello, my hosting company told me that they only support either RAID 1 and RAID 5. so given this choice, w/c would you suggest? i use a MySQL database for a bulletin board application w/c does _LOTS_ of SELECTS and data lookup. thanks in advance, chad _