dp.cx blog

Thoughts from a programmer in (502) - A new post every 99 days!

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.

Posted on

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.

Posted on

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.

Posted on

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.

Posted on

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.

Posted on