Solved

Moving MySQL to SAN

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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Problem description :  Some external hard disks / USB flash drives do not show actual space as mentioned in the factory settings. This is a common problem when you use an 8 GB USB drive to make it bootable to install a firmware/ driver on a serv…
Having issues meeting security compliance criteria because of those pesky USB drives? Then I can help you! This article will explain how to disable USB Mass Storage devices in Windows Server 2008 R2.
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 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…

758 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

19 Experts available now in Live!

Get 1:1 Help Now