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

Re:Show HN: rqlite v2.2.2, replicating SQLite via Raft conse... by otoolep on Tuesday April 26, 2016 @11:27PM (#11577646)

I looked up SQLite VFS. That's pretty interesting, though I am not sure if rqlite has sufficient control over that low a layer in the system, due to the way rqlite is built.

I opened an issue anyway, to look into this.

https://github.com/rqlite/rqlite/issues/108

[ Parent | on HN ]

Re:Show HN: rqlite v2.2.2, replicating SQLite via Raft conse... by tyingq on Tuesday April 26, 2016 @11:35PM (#11577677)

I was really just curious if you had looked at it and ruled it out. Pretty sure it would be a different approach not compatible with the way rqlite works. At the VFS level, you're only seeing the reads/writes/locks to the data file...no visibility to the sql.

[ Parent | on HN ]

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

If you implement a VFS, you have to either implement the WAL subsystem yourself, which isn't pluggable at the moment, or go with journaling mode, which is kinda meh.

[ Parent | on HN ]

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

>>If you implement a VFS, you have to either implement the WAL subsystem yourself

It's pluggable in the sense that it maps the the shared memory calls for WAL to your calls. But yeah, figuring out how to emulate shared memory across a cluster is on the implementer.

[ Parent | on HN ]