7 ms·
VoltDB is out, benchmarks against Cassandra
- aditya 16y agoThis is cool, eventually we'll have every no-sql use case covered, so there exists a data store which conforms to your applications usage with respect to the CAP theorem...
- zipstudio 16y agoI wonder if this DB will be available from any clouds?
- banjiewen 16y agoThis reads like marketing-blogspam to me. These two projects solve totally different problems, and the author acknowledges it, yet he still goes on to highlight benchmarks where VoltDB is 10-20x faster than Cassandra. Of course it's going to be! It's an in-memory store! So why benchmark against Cassandra? It's got a lot of buzz around it, of course. What a better way to shove your name into the "NoSQL" ring. Blech. With regard to the numbers themselves, I would refer the author to the CouchDB boys' discussion of benchmarks (under "Good Benchmarks are Non-Trivial"): http://books.couchdb.org/relax/reference/high-performance http://books.couchdb.org/relax/reference/high-performance
- aweisberg 16y ago"Cassandra writes to disk. VoltDB is an in-memory database. So I gave both systems plenty of RAM to hold the data set and turned Cassandra's consistency settings pretty low." So in memory in both cases. Cassandra has to write a log, but not synchronously.
- skorgu 16y agoI think Cassandra always writes to the Commit Log before returning success, it just doesn't update the SStables yet: > Commit logs receive every write made to a Cassandra node and have the potential to block client operations [1] I'm no expert so it may be possible to turn this off but I couldn't find reference to it. [1] http://wiki.apache.org/cassandra/CassandraHardware http://wiki.apache.org/cassandra/CassandraHardware
- aweisberg 16y agohttp://wiki.apache.org/cassandra/Durability http://wiki.apache.org/cassandra/Durability "Cassandra's example configuration shows CommitLogSync set to periodic, meaning that we sync the commitlog every CommitLogSyncPeriodInMS ms, so you can potentially lose up to that much data in a crash ... You can also select "batch" mode, where Cassandra will guarantee that it syncs before acknowledging writes, i.e., fully durable mode" Cassandra has very fine grained control over just about everything to do with consistency and durability. I believe you can pick your desired level of consistency at access time.
- neilc 16y agoI think Cassandra always writes to the Commit Log before returning success Sure, but the write is not the significant part (it is likely to be cached in memory); the question is how often the commit log is sync'ed to disk. I'm no Cassandra expert, but I believe the default is to fsync() the commit log periodically, but to allow operations to return successfully before an fsync() has occurred. There's also a mode to require fsync() before returning success for an operation. http://wiki.apache.org/cassandra/Durability http://wiki.apache.org/cassandra/Durability
- jefffoster 16y agoFrom their white-paper apparently DBMS systems spend 35% of their time doing buffer management, 17% doing logging, another 19% doing latching and finally 21% doing locking. This leaves only 7% for "useful work". In comparison, VoltDB has 95% capacity for useful work. Reads even more like marketing blogspam!
- ergo98 16y ago>These two projects solve totally different problems No they don't. This is the wavy-hands NoSQL defensive shield that reeks of insincerity. If you show Cassandra or Redis or some other solution replacing a MySQL install, well that's just awesome, but don't dare compare if it doesn't come out the winner. A lot of people have workloads that could work in VoltDB, a classic RDBMS, or Cassandra, equally. There are workloads that only fit in specific silos, but they are less universal than you imply. >So why benchmark against Cassandra? It's got a lot of buzz around it, of course. What a better way to shove your name into the "NoSQL" ring. Blech. Okay this is just silly. Cassandra is the big name in the "next gen database" world -- of COURSE any new entrant is going to compare against it.
- tlack 16y agoThat's like benchmarking Berkeley DB vs. MySQL. They are on totally different levels of complexity. You can't compare memory-only db performance against a disk based db, period.
- ergo98 16y ago>You can't compare memory-only db performance against a disk based db, period. But...you can. What do you mean you can't compare? Clearly you can, however mortified you might be at that prospect. A reasonable motorcycle can go from 0-60 in about 4 seconds. A reasonable car can do it in about 9 seconds. But you need to carry two passengers so the car is your only option, and such a comparison doesn't matter to you, but to a lot of people it's interesting if ultimately they just want to get from A to B as quickly as possibly. Then again if you want to transport goods maybe you need a truck, or a train. This is so silly. Wait -- hand wavy -- that's right, nothing can be compared to Cassandra but pure love itself.
- mileszs 16y agoI don't think it's hand-wavy. I think you're upset about something else related to Cassandra that perhaps you read recently -- not tlack's comment. Suggesting it would make more sense to compare an in-memory data store to another in-memory data store would be a more interesting comparison seems a perfectly valid suggestion. "This is so silly. Wait -- hand wavy -- that's right, nothing can be compared to Cassandra but pure love itself." C'mon, man. That doesn't further discussion. That sort of statement serves only to incite anger.
- seldo 16y agoI'm at Gluecon, where Mike Stonebraker (CTO of VoltDB) gave a talk about Volt this morning. He's very clear that VoltDB is not a NoSQL product; it's a SQL product, but a next-generation SQL product. He says they've achieved enormous performance gains by keeping ACID compliance by throwing out tons of older tech still present in MySQL and Oracle.
- kemiller 16y agoWhat sorts of older things did they throw out? And is there not even eventual persistence with VoltDB? Is there a recovery log or some such? Otherwise it seems like serious power event and you're toast.
- beagle3 16y agoWell, a quick read of their white paper makes it look like they just copied the kdb design (http://cs.nyu.edu/shasha/papers/hpts.pdf http://cs.nyu.edu/shasha/papers/hpts.pdf - which they actually reference in one of their papers). But perhaps they did something new as well? edit: citeseer link was broken; replaced with link to shasha's website.
- hdiedrich 16y agoIt's consistent, not only eventual consistent, it's k-safe, replicated and it's written to disk consistently at intervals you set. http://community.voltdb.com/node/54 http://community.voltdb.com/node/54 (may require login). It's really pretty neat.
- aquark 16y agoIsn't the D in ACID for 'durable'? The blog post implies that this is an in memory store only ... I feel I must be missing something.
- KERMIT 16y ago"Durability" in that sense has nothing to do with how the data is stored, or how long it's available for. It simply means that after a transaction has been reported as having been committed successfully, it won't ever be rolled back.
- pquerna 16y agoin memory vs not, will always have these kinds of results. most people, most systems, aren't so hot about in memory datastores -- MySQL had MySQL-Cluster/NDB, and for lots of reasons it had trouble ever taking off. For certain use cases, and definitely for benchmarking purposes, in memory datastores will always crush the competitors, but in the end, most people like reliable data storage.
- jbellis 16y agoMost use cases also don't have the entire data set equally active, and it's silly to pay to keep everything in RAM instead of just the hot parts.
- hdiedrich 16y agoThat's part of the proposal: real world data requirements will soon completely fit into RAM available on a rather standard system.
- cx01 16y agoIn-memory doesn't imply "unreliable". If you need high-availability you'll want to use replication anyway.
- jbellis 16y agoIn-memory with periodic snapshots sure implies "not durable," though. (That is, you will lose whatever data has not yet been snapshotted on a power failure or crash.) Replication doesn't fix that, unless you're willing to impose the latency of replication to different datacenters for each update. (I don't think Volt even supports this. Most systems don't.)
- cx01 16y agoWhy? If a single node fails, you still have the data on 2 other nodes. Nothing is lost. Of course, assuming you have a reliable UPS.
- bradfordw 16y agoIf he wanted something a bit closer to the voltdb model, why not go with mongo since your writes aren't immediately put to disk? It's more of a measure of how quickly you're shuttling data over the wire. When you agree that it's apples to oranges, why continue?
- codavid 16y agoMy understanding is that mongodb is not durable (http://ivoras.sharanet.org/blog/tree/2010-02-20.mongodb-and-durability.html http://ivoras.sharanet.org/blog/tree/2010-02-20.mongodb-and-...) - I am not sure I understand how VoltDB is durable, though (but then I know nothing about db architecture).
- aweisberg 16y agoMongoDB partitioning support is still under development. Probably more apple to oranges then VoltDB vs. Cassandra.
- riffraff 16y agocode and configurations or it didn't happen
- codahale 16y agoI see absolutely zero details about the actual configurations of either system. No replicability means it's just another opinion paper.