Primary PII
A regulation arrives. The work looks like encryption at first. It is not.
Databases
tag:
databases
all tags →2024
Redis caching patterns
Cache-aside, write-through, write-behind -- and the three problems that make caching hard: stampedes, coordinated expiry, and invalidation.
2021
PostgreSQL HA
Streaming replication, automated failover, and the operational lessons that aren't in the PostgreSQL docs -- split-brain, silent lag, and why DR drills matter more than DR plans.
2018
The week pgbouncer stopped being news
Transaction pooling, one SET that didn't stick, and a standup that moved on.
2013
MySQL on XFS
Using bind mounts to move MySQL data, config, and logs to an XFS volume without changing a single MySQL setting.
2012
Rolling your own search
Building catalog search with flattened MongoDB documents and application-side scoring when the proper tools don't exist yet.