NUMA and MySQL Swap Insanity
A deep dive into why MySQL on NUMA systems suffers from unpredictable swapping, and how a single numactl interleave fix eliminates the problem entirely.
read more
NUMA: An Update to the MySQL Swap Insanity
A follow-up to the original MySQL NUMA swap post, explaining why the real issue is memory pressure on a single NUMA node rather than swap itself, and outlining a three-part solution for balanced allocation in production.
read more
Percona Xtradb Recovery
Percona XtraDB Cluster can recover a crashed node and rejoin it to the cluster using an incremental state transfer. This post walks through how GTID-based position recovery works under the hood and what you will see in the error log during the process.
read more
Permission Rescue: getfacl to Save Your Future Self
A quick reference for backing up and restoring full ACL permissions across an entire directory tree using getfacl and setfacl.
read more
RAID Error Code Key Qualifiers
A quick reference for understanding the key qualifiers that appear in RAID controller error codes, so you can pinpoint the exact failure condition instead of guessing from a generic error message.
read more