SSD Performance and MySQL

A lot of people are wondering whether SSDs make sense with MySQL.  I think that there are cases where they will make sense, and others where they will not.  Here is one test that I came across in a blog entry where the user was excited about SSD performance:

http://labs.cybozu.co.jp/blog/kazuhoatwork/2008/10/benchmarking_ssd_for_mysql.php 

Moving forward, I'm sure that we'll see much more data on this subject and be able to draw more concise lines on when to recommend SSD.

Comments:

That's really interesting Jennifer. I've been thinking a lot about this, and I think you're dead on. There are a lot of cases where SSD is absolutely the way to go, but for some cases it's clearly not the right solution. I'm really looking forward to how things evolve along these lines, especially to see the price/performance ratio.

One thing I'm curious about is the recoverability of an SSD drive. With traditional spindle-based disk drives, there are physical ones and zeros in the magnetic medium. When you have an SSD and it crashes, what then? I think this is largely unexplored territory. You know, recovering data is not an academic exercise. It's a real life need that arises every day when you have enough drives in a data center. This is one of the things the guys at Percona do best -- they are absolute wizards at recovering data from corrupted MySQL instances. I've seen them recover things I and other data recovery experts thought were simply beyond hope. While ZFS and OpenSolaris should add another layer of protection above the disk drive, ultimately the data penetrates all layers and has to be stored on a physical device, and there is always the chance of the filesystem and layers of software getting corrupted in a crash or due to a hardware malfunction or just a bug.

As SSD drives become more widely deployed we'll see a lot more real-world experience in this space, and that will be a compelling value to enterprises who cannot tolerate risk.

Posted by John on November 07, 2008 at 09:06 AM PST #

Hi Jennifer,

i am interested, where you think it makes sense to use ssd with mysql and where not ?!

best regards

andreas

Posted by andreas on September 04, 2009 at 06:47 AM PDT #

A 385% improvement in write speed is really promising. I'll plan my next server storage to be SSD

Posted by mridul on November 25, 2009 at 02:48 PM PST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Jennifer Glore

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today