MySQL and JSON data
MySQL has historically been rather loose with data comparisons. While it has improved, this doesn't feel much different.
MySQL has historically been rather loose with data comparisons. While it has improved, this doesn't feel much different.
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.
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.
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.
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.
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.
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.