The Daily
A note a day on APIs and the realities of shipping web applications. Stuff I've actually learned across 25 years of doing the work.
MariaDB Slow Query Log in Production Without Wrecking Your Disk
The slow query log is one of the most useful tools in MariaDB, and one of the easiest to misconfigure into a disk I/O disaster. Here's how I actually run it.
The slow query log is the first thing I enable when a client's app starts feeling sluggish, and the first thing I disable when I forget to set a sane threshold. I've done both. This post is about doing the former without accidentally doing the latter. What the Slow Query Log Actually Does It's straightforward: MariaDB…
Read the daily →Laravel Horizon's Metrics Lie Under Burst Load
Horizon's dashboard looks calm right up until your queues are backed up 10,000 jobs deep. Here's what it hides and how to catch it early.
Horizon's dashboard is beautiful. It's also one of the most misleading monitoring tools I've leaned on in production — and I say that as someone who genuinely likes the package. The throughput numbers it shows you are rolling averages that smooth out burst load so aggressively you can be in serious trouble before the…
Read the daily →Let's Encrypt in Docker: Ditch the Cronjob, Use a Sidecar
Cronjob-based cert renewal inside Docker is a disaster waiting to happen. Here's the sidecar pattern that actually holds in production.
The cronjob approach to Let's Encrypt renewal inside Docker works fine — until it doesn't, and then it fails silently at 2 a.m. thirty days before your cert expires. I've been burned by this twice, once badly enough that a client's e-commerce checkout was throwing browser warnings on a Monday morning. This is the…
Read the daily →Galera Cluster's Write Penalty Will Quietly Ruin Your Week
Multi-master replication sounds like the right answer until your writes start hanging and you can't figure out why. Here's what Galera is actually doing to your latency.
I spent three weeks diagnosing a latency problem for a client that turned out to be a feature, not a bug. That's the most frustrating kind of bug to find. The setup was a three-node Galera cluster running MariaDB 10.6, hosted across two availability zones on AWS. The goal was high availability with no single point of…
Read the daily →API Versioning in Laravel: The Operational Pain Nobody Warns You About
URI vs. header versioning both work until they don't. Here's where each one actually burns you in production.
Every architecture post on API versioning draws the same clean diagram, explains the two main camps — URI versioning () vs. header versioning () — and then says "choose based on your needs" and moves on. That's where they all stop. I'm going to start there. I've shipped both approaches across a dozen production APIs…
Read the daily →