Show HN: rqlite v2.2.2, replicating SQLite via Raft consensus

Re:Show HN: rqlite v2.2.2, replicating SQLite via Raft conse... by sargun on Wednesday April 27, 2016 @01:53AM (#11578095)

I built one recently. We have a SQLite VFS built on top of Zookeeper for doing metadata-like stuff. We can pull between 1000-100000 reads per seconds out of it.

I realize that this is a total abuse of what Zookeeper does, and how it is supposed to work, but hey, this is a solution that's _simple_ and _correct_.

Here are the benchmarks comparing the traditional VFS with the ZK VFS: https://gist.github.com/sargun/7503ba636c1a0eb2e2f5cda7a6a23...

PS: Feel free to ask me any questions

[ Parent | on HN ]

Re:Show HN: rqlite v2.2.2, replicating SQLite via Raft conse... by tyingq on Wednesday April 27, 2016 @07:02AM (#11579311)

That's the sort of thing I was interested in. Did you split the data up into kv pairs somewhat like this shim: http://www.sqlite.org/src/doc/trunk/src/test_multiplex.c ?

Or is just a small database where 1 sqlite file == 1 key?

[ Parent | on HN ]

Re:Show HN: rqlite v2.2.2, replicating SQLite via Raft conse... by otoolep on Wednesday April 27, 2016 @02:06AM (#11578145)

Pretty interesting. Do you have source code you can share?

[ Parent | on HN ]

Re:Show HN: rqlite v2.2.2, replicating SQLite via Raft conse... by sargun on Wednesday April 27, 2016 @02:57AM (#11578342)

Not yet open source, and it probably wont be for a while, given it's in $EMPLOYER's proprietary product.

[ Parent | on HN ]