[gfody]

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?

[Brian]

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.

[continuum]

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.

[[ETA]MrSpadge]

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

This post has been edited by [ETA]MrSpadge: 18 March 2013 - 04:38 PM