Tuning a MariaDB Galera Cluster for Performance

I originally drafted this article in 2015, when I was managing a production MariaDB Galera cluster for Stockopedia. It’s been gathering dust in my drafts since then. I don’t remember why I didn’t complete it; maybe the subject needed more treatment, maybe I couldn’t find a proper conclusion, or maybe I just lost interest. I don’t know. It’s Jan 2020, I’m finally pushing it out so I can call it done. This article reflects my learning from that period. I have since moved on, both from active duty at Stocko and managing databases in general. The state of the affairs may have improved since, I haven’t kept up. FYI


At Stocko I wear many hats, one involves running a MariaDB Galera cluster as our primary RDBMS. We came to Galera after running a MySQL async replica for a while. Our rationale was to start with what’s built-in, as that is the path of least resistance. In time, we knew we needed a better way to guarantee cluster reliability. After some research, it became clear Galera was the only active, open-source solution that could do multi-master replication.

Read more

Self Updating Git Repos

TL;DR In this post I write a small bash script that updates your Git repos in the background. It is completely hands-free, and pops up a desktop notification whenever it syncs up.

At my workplace I commit to 11 different Git repos. And that doesn’t include my open-source work! If you, like me, have several active projects on Github, it’s not possible to remember to keep them updated. Read more

Parallel processing in Bash

The command line has been the primary interface for Unixes for over 40 years now. It’s design is reminiscent of it’s terminal roots, and it has remained much the same in form and function for decades now.

The terminal, or shell (as we will call it), is batch oriented, i.e: it runs one command at time. But that’s just one part of it. The shell also supports parallel processing, i.e the ability to run multiple commands, asynchronously from a single script. Parallel processing is an old problem and is supported in various ways. In this article I will explore some solutions in BASH , the ubiquitous shell on Unixes, and talk about the pros and cons of each.
Read more

Tech Recipe : Install HAProxy on Ubuntu

HAProxy is a reliable and high performance load balancer for TCP and HTTP(S) based applications.

There are several detailed tutorials around the web on how to install HAProxy. As is usual of my “Tech Recipe” posts, I’ve boiled those instructions down to the quickest way to have HAProxy installed and running on your Ubuntu machine. You will have a running and configured version of HAProxy 1.5 running in under 2 minutes, and ready to go into production. Read more

More Git Branches

In an earlier post I summarized a series of git commands to work with branches. In this post, I attempt to classify those commands, according to their purpose. My approach in this article is to take a series of common development scenarios using git and see how we can solve them. At the end of the article we will use what we have learnt (and some) to create a couple of useful git aliases.

Read more