Philip O'Toole

Philip O'Toole

Replacing Postgres with rqlite

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. Recently I helped Replicated replace their use of PostgreSQL with rqlite. This brought much easier operation and high-availability to their Application Manager.

rqlite 7.10.0 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. Replicated, a company which helps software vendors ship software to end users, recently migrated from PostgreSQL to rqlite. Along the way their…

rqlite 7.8.0 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 7.8.0 provides more convenient options for retrieving a backup of the underlying SQLite database. The guide for running rqlite on Kubernetes has…

rqlite 7.7.0 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 7.7.0 is the first release to add support for non-deterministic functions, specifically RANDOM. It accomplishes this via statement-rewriting. Many thanks to Ben…

rqlite 7.5.1 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 7.5.1 supports more network-related configuration options. You can download the release from GitHub.

Testing rqlite read consistency

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. Nienke Eijsvogel, Ruben van Baarle and Daan de Graaf recently ran Jepsen-style testing of rqlite. Their tests showed that rqlite maintains linearizability…

rqlite 7.3.2 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 7.3.2 upgrades rqlite to use SQLite 3.38.0. You can download the release from GitHub.

New Slack channel for rqlite

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine and Raft for distributed consensus. I’ve created a new Slack channel for discussions on rqlite, so be sure to sign up if…

Why are we still tailing log files?

Sit down with any developer today, even those at pretty new software companies, and you’ll see them doing something that programmers have been doing for years — you’ll see them tailing log files. But why? Why are we still tailing…

rqlite 6.9.0 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 6.9.0 adds support for SQLite Named Parameters. You can download the release from GitHub.

rqlite 6.8.2 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 6.8.2 adds control over startup initialization. You can download the release from GitHub.

rqlite 6.6.2 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 6.6.2 increases maximum intra-cluster communication message size. You can download the release from GitHub.

rqlite 6.6.1 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 6.6.1 improves handing of some error cases. You can download the release from GitHub.

Using Ansible to deploy WordPress

I want to make this WordPress deployment easier to replicate — both to make it much easier to recover from failure, and experiment with various configurations. To that end I finally got around to using Ansible to deploy it. It…

rqlite 6.6.0 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 6.6.0 adds supports for recovering clusters that have permanently lost quorum. You can download the release from GitHub.

rqlite at the CMU Database Group

I recently had a chance to speak about rqlite, the distributed, lightweight database built on SQLite, to the Carnegie Mellon Database Group.We discussed the goals of rqlite, its design and use of the Raft consensus protocol, as well as testing…