4 ms·
The article is a blatant advertisement. Let me counter-advertise with my experiences here. We did evaluations of a Fusion-io ioDrive card and a Texas Memory S
by seiji 17y ago
The article is a blatant advertisement. Let me counter-advertise with my experiences here.
We did evaluations of a Fusion-io ioDrive card and a Texas Memory Systems RamSan card [1] recently. The ioDrive had strange performance characteristics (but nicely designed packaging). We ended up going with a few RamSan cards (though, they have much uglier packaging).
We have a few high throughput MySQL instances that needed to perform better. The database in question is only a few hundred gigabytes in size, so it's a perfect fit for the current generation of server flash cards.
Our path for improving improving performance went:
- Started off with 32GB RAM and RAID-10 on SAS disks.
- iowait sat between 10% and 15% constantly.
- Moved up to 64GB RAM.
- iowait cut in half.
- Installed RamSan card and moved mysql with all databases to it.
- iowait became negligible.
Now the server sits there with a few hundred gigabytes of flash, 64GB RAM, and it looks completely idle on usage graphs, but it's serving data faster than ever.
They are nice devices if you can afford them (and tolerate their quirks like needing to be completely formatted during firmware upgrades).
[1]: http://www.ramsan.com/products/ramsan-20.htm http://www.ramsan.com/products/ramsan-20.htm
- angusdavis 17y agoCurious, did you get these performance gains with off-the-shelf Mysql+myisam, or did you consider YC company rethinkdb (http://www.rethinkdb.com/ http://www.rethinkdb.com/)?
- seiji 17y agoIt's MySQL with the Percona patches using InnoDB (not XtraDB yet). I've looked into rethinkdb, but it's not quite yet ready for a bet-the-company-on-it install. We didn't order any extra $10k+ flash cards just to play around with. The RamSan flash cards took a while to get ahold of too (the government (NSA if I recall correctly) buys them by the thousands).
- pmorici 17y agoIs this worth the cost premium? It seems like you could get similar performance using 4 standard SATA SSD drives in a stripped RAID and the cost would be a bit less than 2k.
- hristov 17y agoHave you used them long enough to gauge longevity? How long do they last you? Do you have to use any special software to ensure there are not too many rewrites?
- c00p3r 17y agoIn many cases heavy raids is an overkill. just a hardware mirror + replication on slow backup servers could be a tradeof.