Building Secure and Reliable Systems at Google

I recently started reading Building Secure and Reliable Systems, which was authored by various folks at Google (some of whom I know). Since my work is at the intersection of so much of this — reliable logging systems which must also be secure, it’s an interesting read.

In my experience, the most challenging part about securing our systems are the constant trade-offs one needs to make. Since no system can be made 100% secure, knowing where the marginal risk is no longer worth addressing is quite difficult — I’m hoping this book improves my ability to make these trade-offs correctly.

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 wasn’t too difficult, though there is much yet to do.

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 6.4.3 released

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. 6.4.3 includes important bug fixes related to large databases, and improved status and diagnostics.

You can download the release from GitHub.

rqlite 6.1.0 released

rqlite is a lightweight, open-source, distributed relational database written in Go, with SQLite as its storage engine. 6.1.0 enables new SQLite options including JSON1 support and the DBSTAT table. It also supports proper concurrent database reads for in-memory databases, and write requests no longer block those reads.

You can download the release from GitHub.