3Ware makes reasonably priced ATA and SATA RAID-5 cards (IDE, not SCSI). You can get hot-swappable enclosures so that when a drive fails, you swap it without shutting down the machine.
We are gradually adding this hardware to our webservers, etc so that we don't have to rebuild them when a drive dies. Some good URLs: http://www.3ware.com/ These guys sell the cards at a good price, plus they sell 3rd-party enclosures (I've used them with 3ware, and they work great): http://www.pc-pitstop.com/ David. ----- Original Message ----- From: "Lefevre, Steven" <[EMAIL PROTECTED]> 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 > no performance benefit, and actually the computer might have to work harder > to make sure the drives are in sync. > > Disk striping makes things *fast*, BUT THERE IS NO PROTECTION. If you lose a > drive, you are screwed; hope you have a backup. > > Raid 5 spreads data out over all the disks, and keeps one for checksums or > whatever. You lose only one drive to the checksum. > > 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. > > You get great redudancy, because if you lose one disk, the RAID still > operates (in 'degraded mode') -- it's slower, but the server is still up. > When you get your replacement drive in, you just hook it up, and the RAID > rebuilds itself. > > So, all in all, RAID 5 gives fault tolerance and better performance. > > You can have the OS do the RAID, but that puts a lot of burden on the > processor and OS. I recommend getting a RAID card, and not a cheap one, > either. Plan on spending ~$500. > > > -----Original Message----- > From: Jackson Miller [mailto:[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 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 RAID? > > -Jackson > > jackson miller > > cold feet creative > 615.321.3300 / 800.595.4401 > [EMAIL PROTECTED] > > > cold feet presents Emma > the world's easiest email marketing > Learn more @ http://www.myemma.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]