rqlite is a lightweight, open-source distributed relational database, with SQLite as its storage engine. v3.12.1 has been released. This release includes integration with a new Discovery Service, allowing nodes to automatically connect and form a cluster. This can be very convenient, allowing clusters to be dynamically created.
You can download the release from GitHub.
rqlite is a lightweight, open-source distributed relational database, with SQLite as its storage engine. v3.10.0 has been released. This release includes some minor configuration control and logging enhancements.
You can download the release from GitHub.
rqlite is a lightweight, open-source distributed relational database, with SQLite as its storage engine. v3.9.2 is now out. This release includes a couple of significant bug fixes.
You can download the release from GitHub.
rqlite is a lightweight, open-source distributed relational database, with SQLite as its storage engine. v3.8.0 is now out. This release includes some minor enhancements and bug fixes.
You can download the release from GitHub.
rqlite is a lightweight distributed relational database, with SQLite as its storage engine. With release v3.7.0 you can load SQLite dump files directly into rqlite. This makes restoring from a backup, or migrating an existing SQLite database to rqlite much easier.
You can download the release from GitHub.
rqlite is an open-source distributed relational database, with SQLite as its storage engine. v3.6.0 is out. With this release a new node can now join an existing cluster though any node of that cluster, not just through the leader node.
You can download the release from GitHub.
rqlite is an open-source distributed relational database, with SQLite as its storage engine. v3.5.0 is out. This release supports important control of foreign key constraints, in the underlying SQLite database.
You can download the release from GitHub.
rqlite is an open-source distributed relational database, with SQLite as its storage engine. v3.4.1 is out. This release includes some minor fixes as well as source code improvements (linting).
You can download the release from GitHub.
rqlite is an open-source distributed relational database, with SQLite as its storage engine. v3.4.0 is out, which includes a minor change to the HTTP responses.
You can download the release from GitHub.
rqlite is an open-source distributed relational database, with SQLite as its storage engine. v3.3.0 has been released and includes new functionality to control the Raft consensus subsystem, along with improvements to the CLI.
You can download the release from GitHub.
rqlite is an open-source distributed relational database, which uses SQLite as its storage engine. rqlite is written in Go and uses Raft to achieve consensus across a set of SQLite databases. It gracefully handles leader election, and can tolerate machine failure.
With the v3 release series, rqlite can now replicate SQLite databases on a global scale, with very little effort. Let’s see it in action using the AWS EC2 cloud.
To help with the growth of rqlite, it’s been moved to a new repository, under a dedicated organization. Github made this transfer very easy.
I decided on a new logo too.
rqlite is a replicated relational database built on SQLite, with distributed consensus provided by the Raft consensus protocol. It gracefully handles leader election, and can tolerate machine failure.
Written in Go, v2.2.1 is out now.
Continue reading rqlite v2.2.1 released with HTTPS, Basic Auth, and user permissions
rqlite provides robust replication for SQLite databases using the Raft consensus protocol. Coded in Go it ensures that all changes made to the leader SQLite database are replicated to all other nodes in the cluster, providing fault-tolerance and reliability.
It’s been 18 months since development of rqlite first started and it’s time for version 2.
Continue reading rqlite – replicated SQLite with new Raft consensus and API
I’ve started replacing go-raft within rqlite with the implementation from Hashicorp. go-raft is no longer maintained, and I’ve good experience with the Hashicorp code, due to my work with InfluxDB and hraftd. I’m also going to change the API, so it’s more useful. The existing implementation and API has been tagged as v1.0, so it’s still available.
You can follow the work on this branch, and I hope to merge it to master in the near future.
Hashicorp provide a nice implementation of the Raft consensus protocol, and it’s at the heart of InfluxDB (amongst other systems). I wanted to experiment with a simple system built using this particular Raft implementation, so was inspired by raftd to built hraftd.
Continue reading Building a distributed key-value store using Raft
SQLite is a “self-contained, serverless, zero-configuration, transactional SQL database engine”. However, it doesn’t come with replication built in, so if you want to store mission-critical data in it, you better back it up. The usual approach is to continually copy the SQLite file on every change.
I wanted SQLite, I wanted it distributed, and I really wanted a more elegant solution for replication. So rqlite was born.
Continue reading Replicating SQLite using Raft Consensus
