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
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.
From: Jackson Miller [mailto:jackson@stripped]
Sent: Thursday, August 21, 2003 11:56 AM
To: Jon Drukman
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
I would say I am running about %50 SELECTS, 30% UPDATE, 20% INSERT. However
don't know how to find that out for sure.
Would that affect how I set up the RAID?
cold feet creative
615.321.3300 / 800.595.4401
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