Best Raid Setup

Posted on 2009-04-23
Last Modified: 2012-06-27

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,1635.html,1662.html,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.
Question by:Pyromanci
    LVL 5

    Accepted Solution

    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)

    When you look at what raid options and all you care about it speed, then you might

    We use the 9650SE line.

    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.

    LVL 2

    Expert Comment

    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.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Both Easy and Powerful How easy is PHP? (  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
    Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now