Solved

Moving MySQL to SAN

Posted on 2009-03-30
2
442 Views
Last Modified: 2013-11-14
We are moving our databases to an EMC CX320 but we do not have any recommendations on what file system to use on the SAN to support our large databases. We currently use ext3 but it has issues with really large partitions over 2Tb. We also have an issue with finding a file system that supports MySQL's "innodb_flush_method = O_DIRECT". A MySQL support rep suggested using Linux GFS but this seems to entail running the linux cluster software which sounds like overkill. Has anyone run a write and read intensive MySQL database on a SAN and if so have any tips on configuring the filesystem for such a load.
0
Comment
Question by:csnetops
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 18

Accepted Solution

by:
BigSchmuh earned 500 total points
ID: 24022918
Why don't you go with "raw device" (see below for MySql 5.0) for large tables and jfs for others ?
   http://dev.mysql.com/doc/refman/5.0/en/innodb-raw-devices.html

A raw device does not require a fs and is directly managed by MySQL (it is even faster than any O_DIRECT option). Of course, you can not backup the raw device directly (offline backup only) but there are MySql Utilities to do that.

Regarding ext3, I read (see below) a complaint about ext3 O_DIRECT fs causing some cpu ticks to be dropped
   http://www.mt-soft.com.ar/2008/04/20/do-not-use-o_direct-with-ext3-2/
0
 
LVL 18

Assisted Solution

by:BigSchmuh
BigSchmuh earned 500 total points
ID: 24022992
Next is the SAN usage because every array is designed to better support some block size than others.

Example: A raid 5 array of 10 drives using a 64KB chunk size (=9x64KB full stripe size) will definitely better perform when used by a 64KB block io client than by another io client
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
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…

691 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