Sign in to follow this  
Followers 0
gfody

Intel 910 vs. FusionIO/ioDrive

5 posts in this topic

I'm wondering if anyone has tested and compared these products?

Intel 910 800GB is ~$4k and does 180k/75k iops 4k random read/write

FusionIO ioDrive2 785GB is ~$10k and allegedly does over 900k iops

The only head to head I could find for db load is here:

http://www.ssdperformanceblog.com/2012/09/intel-ssd-910-in-tpcc-mysql-benchmark/

..seems like the ioDrive's performance improvement is only marginal. Anybody have links to benchmarks or first hand experience they can share?

Share this post


Link to post
Share on other sites

A belated answer, but...

Keep in mind that the internal architecture of MySQL is decades old. MySQL spends a great deal of time on data locking, SQL query optimization, shuffling data between layers, etc. Thus even if your storage subsystem was "infinitely fast" and all storage commands returned instantaneously you would still be limited in how fast MySQL can go.

You'll have to verify this yourself, but my hunch is that in mixed real'life workloads MySQL won't be that much faster on Fusion-IO, not enough to warrant the price.

If you need more than MySQL + Intel 910 gives, then you have two main choices: Find a more scalable RDBMS (i.e. crazy expensive Oracle), or scale horizontally (partitioning over multiple MySQL instances, NoSQL, etc).

Share this post


Link to post
Share on other sites

Well right now we'd love to show the Intel 910 in our MySQL (and future application tests) but our sample failed. One of the four controllers died (operates in RAID0) putting it out of commission. Hoping Intel can send a replacement soon, but its been over a month or so now with no replacement.

Share this post


Link to post
Share on other sites

Well right now we'd love to show the Intel 910 in our MySQL (and future application tests) but our sample failed. One of the four controllers died (operates in RAID0) putting it out of commission. Hoping Intel can send a replacement soon, but its been over a month or so now with no replacement.

Hey Kevin - I work @Intel and saw your post. Wow - over a month, that's not right - waaay too long for you to be waiting. If you send me your RMA number, I'll do some checking for you and we'll find out what's holding things up & get things moving quickly for you. Feel free to email me directly at rick.t.reed@intel.com

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