mysql

The worst phone call any DBA can get is “production is down and we need last night’s backup…

I’ve never regretted having an extra backup, but I’ve absolutely regretted not having one. Early in my career,…

Query optimization is the skill I’ve spent the most years refining, and honestly, I don’t think I’ll ever…

If there’s one topic that separates people who can write SQL from people who can actually run a…

Replication is the point where I feel like I graduated from “person who runs a database” to “person…

Connecting to a remote MySQL server sounds trivial until the moment it doesn’t work, and then I’m suddenly…

Deleting data is the operation I approach most carefully out of everything MySQL lets me do, because it’s…

Of all the DML statements I write, UPDATE is the one I treat with the most respect, because…

If installing MySQL is the foundation, then querying data is the room I actually spend most of my…

Every application I’ve ever built eventually comes down to this: getting data safely and efficiently into a table.…