Solved

Moving MySQL to SAN

Posted on 2009-03-30
2
440 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Duplicated data in GROUP_CONCAT 2 50
is NetApp FAS8200 downgradeable to ONTAP 8.3.x 2 91
Mysql how to execute a commands file 5 39
mysql vs miscrosoft sql server 6 60
Concerto Cloud Services, a provider of fully managed private, public and hybrid cloud solutions, announced today it was named to the 20 Coolest Cloud Infrastructure Vendors Of The 2017 Cloud  (http://www.concertocloud.com/about/in-the-news/2017/02/0…
When we purchase storage, we typically are advertised storage of 500GB, 1TB, 2TB and so on. However, when you actually install it into your computer, your 500GB HDD will actually show up as 465GB. Why? It has to do with the way people and computers…
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…

734 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