Jump to content


Photo

consumer grade SSD in production database server


  • You cannot start a new topic
  • Please log in to reply
3 replies to this topic

#1 gfody

gfody

    Member

  • Member
  • 144 posts

Posted 16 March 2013 - 06:07 PM

considering that enterprise SSDs are 10-20x more expensive than consumer SSDs - is anyone using consumer SSDs in a RAID for a production db server? If so can you share your raid configuration, what drives you used, what kind of performance you get and how the SMART counters are predicting remaining drive life over time?

#2 Brian

Brian

    SR Admin

  • Admin
  • 5,298 posts

Posted 17 March 2013 - 11:49 AM

A lot of people are doing this. Though the price delta you mention isn't that wide any more, it's more like 2-2.5X for a decent enterprise drive. Samsung is targeting you specifically with the SM843, essentially a client drive with a little more OP, but it's definitely read tuned. I'd be thinking pretty hard about spending a little more to get the S3700 or something like the P400m or SF alternatives. Really depends on the nature of your DB and how compressible it is.

Brian

Publisher- StorageReview.com
Twitter - @StorageReview

 

#3 continuum

continuum

    Mod

  • Mod
  • 3,566 posts

Posted 18 March 2013 - 04:07 PM

As Brian says, depends what you need. Heck Anandtech is running X25-M G2's in some of their new production servers, and we have at least one customer internally running Intel 520's...

That said it's not just a simple case of is-SSD-suitable, as you're already aware, system usage/type/hardware configuration has a huge effect.

#4 [ETA]MrSpadge

[ETA]MrSpadge

    Member

  • Member
  • 742 posts

Posted 18 March 2013 - 04:37 PM

In read centric workloads I wouldn't see general problems due to using regular SSDs, if:
- the RAID takes care of drive failures
- the performance is high enough
- performance consistency is good enough (the S3700 really shines here)

Edit: Anand is unsing the X25-M G2's for read centric servers and X25-E's for the database.

MrS

Edited by [ETA]MrSpadge, 18 March 2013 - 04:38 PM.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users