Databases on solid state disks

For years, companies that run high-performance data-intensive web applications (like ours), have focused on putting everything possible in RAM… heavy DB caching, IMAP indexes, Search indexes, etc.  And we have been eagerly awaiting the day when we can affordably put this data on solid state disks.  We’re close now… real close.  You can even get an SSD for your MacBook Air.

I’ve been following Kevin Burton’s dive into MySQL performance on solid state disks.  Here is his final summary.  I recommend reading his entire series of posts on the topic.

There’s a bit of quirkiness when running a database on SSDs, but the results are very promising.  I can’t wait to put some of these in our servers.

Kevin’s tests were all with MySQL InnoDB and MyISAM tables, but he briefly touched on a few buzz words in his closing remarks:

> Also, if youโ€™re using something like Bigtable via Hypertable or Hbase
your performance should be
> stellar since these are append only
databases and SSDs do very well with sequential reads and writes.

One thought on “Databases on solid state disks

  1. Kevin Burton

    Yeah.. I’ve been waiting for commodity solid state storage since I was about 15…. which was 17 years ago.. ug.
    This is why I’m so excited about SSDs.
    BTW. My Grandfather’s name is Bill Buebel so every time you link to me it’s confusing ๐Ÿ˜‰
    Don’t stop though ๐Ÿ™‚
    Kevin

    Reply

Leave a Reply to Kevin Burton Cancel reply

Your email address will not be published.