Every couple of years I rebuild my main development VPS for some reason or another. Months ago I realised that I had gradually worked my way up the DigitalOcean spec list but was now using a fraction of the resources. I held off rebuilding too soon though as I was relying on the IP address assigned for access to a particular work network. However, now that situation is resolved with something far less brittle it's time to get on with it.
As part of an ongoing experiment with kubernetes and lots of WordPress instances I wanted to set up a site that talked to an Amazon RDS MySQL database. The unknown part was how to do this over SSL using the WordPress docker image...
You would expect identical SQL queries, running against the same database at the same time to give the same results, right? Well, it turns out that such an impossibility can occur. Alas, this wasn’t some easter egg or heisenbug hidden in MySQL, the issue turned out to be perfectly sane. This is how the confusion unfolded…