I am currently in the planning stages for a change over for our companies point of sales software. This new software is a live database system and it utilizes MySQL as it's database.
So I have talked with the software designers and have done some basic load tests based on how many SQL statements will be hitting the database in a given day and figure out the RAM, CPU, and Bandwidth I'll be needing.
The last thing which i can not seem to narrow down is the ideal RAID configuration for the Hard drive. I guess this is truly a matter of opinion, but I do really need to figure out what is going to be the most optimal configuration.
Redundancy really isn't a issue. I'm going to be having 2 to 3 other servers acting as MySQL childern to make use of MySQL replication ability for backup (since this server does nothing but MySQL).
I guess I should include some of the base server hardware as I know it does play a small roll. Its going to be a linux server with 12GB RAM (on the low end, I may end up having to increase it to 16GB or 24GB) and a Quad-Core 2.5 GHz Xion processor.
Now based of what i have read about, which can be found here
and based on the other articles, a pure MySQL server machine needs a low seek time, but a decent I/O performance.
So based on that what would be the ideal configuration? Raid 0/0+1/1/5/6? How many drives? Pretty much at this point i am at a loss.