MySQL Users, Authentication Order, and Anonymous Logins

Last week we ran in to an issue wherein MySQL stopped allowing logins from several of our user accounts. This post documents how that happened, and what you might need to prevent this issue going forward.

How to fix strange characters in MySQL

I admit, I borrowed this from How to fix strange characters in MySQL database – Vinh Pham. But I also added a few more that were missing.

MySQL monitoring script

A commenter recently asked if I could publish the script that I wrote to handle monitoring master-master replication. It's been almost two years since I wrote the code, and I no longer have access to the original, but I've reproduced the general code here.

Dirty reads with software raid?

Is it possible software raid 1 to not actually record data writes until some time later? I know it's possible with hardware raid, but I've never heard of that with software raid.

Cloning all of an organizations git repos

Some of the code at $job (sadly) uses blind inserts, which makes changes to the tables behind them tricky. We were about to embark on a series of changes to tables for our Data Warehouse project, and I needed to verify if anything would be affected by these table changes.

Creating an Online Life Timeline

Recently, I've been interested in building a timeline of my online life. Essentially, anything that "happens" to me, online, should be recorded by me somehow.

MySQL and support for Daylight Saving

I've already written once about Daylight Saving and how much I hate it. It came back to bite me anyway.