mflorell wrote:"In software implementations of RAID-5, which are fairly common, performance will often become unacceptably slow if writes make up any more than about 15% of disk activity."
This would be why I said "HARDWARE" RAID in all caps. Because YES software raid is commonplace, and kinda sucks. But in my experience HARDWARE RAID is essential for enterprise level installations which have zero tolerance for downtime.
Explaining to the CEO that it will only be down for an hour is NOT what I consider to be a fun day (when he quotes what it will cost the corporation in real dollars).
Explaining that it will operate slowly for another 20 minutes while the RAID rebuilds the recently replaced drive, that I can live with. My experience has been the realm of 80% capacity during the rebuild. Add redundant power supply and you have removed TWO of the normal "down system" generators from your system. Next we have an extra NIC (twin gigabit is actually fairly inexpensive thse days), this reduced your "down system" to things like memory, motherboard, router, etc., none of which is extremely commonplace (well, depending on how cheap your routers are).
The articles you pointed to complained about software RAID and said that MOSTLY read access is improved (more so than Write Access), but consider what happens when your Mix Monitor goes to work after a large quantity of recordings have been made. Speeding the read portion of that up won't hurt a bit. And I will take any increase in drive speed I can take that has no impact on CPU.
It also said that RAID 1 "does not require significant levels of CPU for normal operation or recovery", I'm betting that ANY CPU usage is a bad thing, and HARDWARE RAID is essential to remove any CPU hit. If the RAID is on the motherboard, similar to shared video memory, I'm thinking there's a CPU hit, so ... HARDWARE RAID means "buy a card".
Also, as the article says, everything on disk 1 is duplicated onto its mirror, therefor, as I said before, a corrupt sql table will also be corrupt in the mirrored disk, so you'll still need to get a tech and have him do a "restore". 20-30 minutes even if he's in the building. So you cut your hard drive usage in half, slowed down your system and still didn't keep the system "up". Which is why I said RAID 1 is marvelous, but not for a MySQL system.
How many MySQL problems have I seen posted that were resolved by rebuilding tables? ... but a Tech has to do this, and there's still the possibility that the rebuilding of the tables will fail and a FULL backup from last night would be beautiful.
So I recommend a nightly full sql backup and not the mirror (unless you want to spend the money, and then I still prefer the speed help and realiability of HARDWARE RAID 5) for a system with MySQL. If this is a "scratch" MySQL install, it's all in one box ... so MySQL is there.
In the end, the advantage to RAID 1 is ... you may not need a tech (right then), but you will not see a speed advantage, and my personal experience (on several systems) has been that when the drive dies (and yes, I've responded to a lot of dead drive), the system goes DOWN or slows down so far (as the drive fails) that the entire mirrored system seems like it's at 20% speed (because the mirror is trying to write on both drives, but one is dragging it down).
As with those "commonplace software RAID 5's" ... Most "mirror" systems are cheap and on the motherboard (not true "RAID" controllers) and cannot recover from a bad situation easily. Generally a tech must get involved and yank the dead drive. This sort of situation has always translated to a "Down System" phone call, and an immediate discussion of RAID 5 to avoid this in the next dead drive occurrence.
But, yes, RAID 5 costs even more money than RAID 1, however, my personal experience with RAID 5 is that you must purchase an actual RAID controller with the ability to detect and remove a dying/dead drive which immediately puts the system back to operation with whatever drives are left (down from 5 to 4 = not as good as 5, but still faster than a single drive). If the dead drive drops you to 2 ... you now have a mirror. And with all of them (mirror or RAID 5) you have automatic healing when a new drive is introduced if the system is any good.
Please tell me you didn't read all that.
Someone needs to drive to Florida so we can build parallel systems and really compare this on two machines sitting side by side. I'd love to see a comparison beyond my personal collection of "moments" with senior management. Noone wants to spend the money up front, but after they lose the money in a two-hour down ... suddenly the Operations Department wasn't loud enough about the importance of spending more money to "do it right".
Hard drives die ... if they die when the system is offline, or if you can just "shunt" to another machine, that's fine, but if you can't ... Redundant Power Supply, Spare network interfaces, RAID 5 can keep your system online until the shift ends.
Please excuse my rant. Should I delete it?