[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1440
  • Last Modified:

Best Raid Setup

Hello,

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
http://www.tomshardware.com/reviews/RAID-SCALING-CHARTS,1635.html
http://www.tomshardware.com/reviews/RAID-SCALING-CHARTS,1662.html
http://www.tomshardware.com/reviews/RAID-SCALING-CHARTS,1735.html

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.
0
Pyromanci
Asked:
Pyromanci
1 Solution
 
tkfastCommented:
With Linux not sure what distribution you are looking at but if you are running 2.6 kernel here are some benchmarks for the 3ware card.  We use these in our MYSQL server's with great performance and you can easily monitor the controller without the overhead of other brands.  We have used adaptec, but they use much more server over head to monitor the card and DELL Perc are poor performs in linux and kill server performance when trying to run monitoring tools on the array.  

This document also helps in understand how a 3ware raid performs with raid 5 vs raid 0 in read and write performance.  (page 7)
http://www.3ware.com/KB/attachments/9550SX%20Optimized%20Performance%20Report%20Windows%20Linux%20final%20112905-GUID2c04cae86dd64778a121ea2b24b60b36.pdf
 
http://www.3ware.com/KB/attachments/Linux2.6WP_0701.pdf
When you look at what raid options and all you care about it speed, then you might

We use the 9650SE line.
http://store.3ware.com/?category=10&subcategory=8

When you are wringing and reading from a MYSQL database your are not dealing with large file sizes so some comparisons are are on large file read and writes when you will be doing lots or small read and writes.  

Hope that give you a little help traditional we use RAID 5 but that is for redundancy as well as performance but if redundancy does not matter then I would go RAID 0.

You might also want to look at this.
http://www.drbd.org/




0
 
MathiauCommented:
We have a 3ware 9690 series and it's performance is ridiculous, with 6 Segate ES2 SATA drives i can not get over 128MB in a raid 50 array, watch out with those 3ware SATA cards, they do have some compatibility issues and firmware on harddrives often need to be specific for it to work properly.

Adaptec new line out is very fast as well as Areca 1680 series.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now