Solved

Optimizing RAID10 for MySQL Enterprise DB

Posted on 2011-09-25
3
858 Views
Last Modified: 2012-05-12
We have recently bought:
RS700-E6/ERS4
2x Quad Core Xeon X5570
64GB RAM DDR3 ECC
4x Cheetah 15K.7 300GB 6 Gb/s SAS 2.0

I have set this config up in RAID1+0.
We will be running a MySQL Enterprise Database on here, for RADIUS purposes.

I am wondering what the best RAID controller setup would be for this purpose.
I have the option to set the following options:
Strip Size: 8-1024KB (default 64k)
Read Policy: Normal / Ahead
Write Policy: Write through / Write back
IO Policy: Normal / Cached
Drive Cache: Enabled / Disabled
Background Initialization: On / Off

NCQ: Enabled/Disabled
Patrol Read Ahead: (default 30)
Coercion Mode: None / 128M-way / 1GB-way

I am especially interested in information about the strip-size
but all other recommendations are also very welcome!
0
Comment
Question by:redworks
3 Comments
 
LVL 18

Accepted Solution

by:
BigSchmuh earned 500 total points
ID: 36599164
IF you bought the BBU (battery unit) for your raid card, you can turn on the "write back" cache, otherwise please keep away from it.

I would take care of aligning the RAID 10 array to 1M to avoid misaligned io.
Most Linux and Win2003/XP DOES NOT align correctly the usable data in a partition.

Regarding the stripe size, I think MySQL default's using 128KB pages, so I would go with 128KB stripe to issue full stripe io query on most time. 256KB, 512KB or 1MB may be benchmarked if you have time for that.

Now, with 64GB of RAM, you should have a great "cache hit ratio" and may be most physical io can be rendered as sequential by MySQL ... which means a 1MB stripe could be better than anything else.

Appart from that, having RAID 10 does not allow to forget to backup and have an offsite backup.
0
 
LVL 27

Expert Comment

by:Dr. Klahn
ID: 37169567
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A clone is a duplicate copy. Sheep have been cloned and maybe someday even people will be cloned, but disk cloning (performed by the hard drive cloning software) is a vital tool used to manage and protect data. Let’s look at what hard drive cloning …
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

679 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