News for hackers. Stuff that matters.
Re:Why some NoSQL DBs only let you perform transactions on a... by shin_lao on Friday October 30, 2015 @09:24AM (#10477600)
Sorry to say but we have something that is truly transactional and distributed (https://www.quasardb.net). It slows down a bit writes (because of the commit) but it scales well.

And before us FoundationDB delivered the same feature (although implemented a bit differently).

The truth is that there is a market for databases with "unreliable" writes and there are easier to design. That's why you see a lot of them.

Re:Why some NoSQL DBs only let you perform transactions on a... by scott_s on Friday October 30, 2015 @10:04AM (#10477856)
You do not disagree with the author. Quoting from his post:

Given that distributed transactions necessitate distributed coordination, it would seem that there is a fundamental tradeoff between scalable performance and support for distributed transactions. Indeed, many practitioners assume that this is the case. When they set out to build a scalable system, they immediately assume that they will not be able to support distributed atomic transactions without severe performance degradation.

This is in fact completely false. It is very much possible for a scalable system to support performant distributed atomic transactions.

In a recent paper [http://cs-www.cs.yale.edu/homes/dna/papers/fit.pdf], we published a new representation of the tradeoffs involved in supporting atomic transactions in scalable systems.

Re:Why some NoSQL DBs only let you perform transactions on a... by eis on Friday October 30, 2015 @10:33AM (#10478017)
What are you using LevelDB for? I hope not the main KV store.

Do you use 2PC or something like Raft to handle distributed transactions?

From the docs it sounds like everytime a node joins/leaves the cluster goes into a (brief?) unstable mode and failures can happen, that doesn't sound great.

Re:Why some NoSQL DBs only let you perform transactions on a... by shin_lao on Friday October 30, 2015 @01:02PM (#10479008)
I'm happy to see you've read the documentation thoroughly!

We indeed stopped using LevelDB. It has been used for a while but we couldn't work around some speed issues. LevelDB is good for many scenarii when properly configured, though.

The database is multilayered, LevelDB was the last layer, most parallel operation were managed by a massively parallel in-memory database which used LevelDB as a backend.

We do 2PC to handle distributed transactions. Raft breaks our consistency model.

When a node joins/leaves the cluster you might have some transient failures which are generally absorbed by the protocol.

I hope I answered your questions and feel free to give it a spin next week, we're about to release a major update!

Re:Why some NoSQL DBs only let you perform transactions on a... by teraflop on Friday October 30, 2015 @01:03PM (#10479013)
Is there something particularly wrong with LevelDB? It may not have all of the bells and whistles you could possibly want from an on-disk key-value store, but it seems like a perfectly serviceable building block to put a database on top of.