MySQL Forums
Forum List  »  MySQL & Storage

Re: MySQL and SAN
Posted by: Peter Zaitsev
Date: February 27, 2006 06:47PM

MySQL does not really care if you use SAN or directly attached hardware. In fact it does not even know.

We have number of customers using SAN with mixed results. Some are happy some went back to directly attached hardware, using large amount of MySQL boxes instead and MySQL replication or Partitioning (more likely for 2TB)

One thing you should keep in mind - SAN are good for ease of management, but they do you no magic in terms of performance. Well... They do in a sense as they may have very lage number of hard drives, but do not expect much better performance per drive, unless your application working set fits in SAN memory of course.

SAN are also likely to increase latency even though they have good throughtput, so for latency critical sequential writes, such as log files you may consider using directly attached
couple of drives with battery backed up cache - this is if log writes are being bottleneck for you.

Options: ReplyQuote


Subject
Written By
Posted
September 22, 2005 07:53AM
Re: MySQL and SAN
February 27, 2006 06:47PM
January 12, 2007 12:54PM
February 27, 2006 07:46PM
March 29, 2006 03:02PM
January 12, 2007 12:56PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.