Sign in to follow this  
Followers 0
gfody

consumer grade SSD in production database server

4 posts in this topic

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0