We replaced Redis with MySQL for inventory reservations—and it scaled (2026) - Shopify

We replaced Redis with MySQL for inventory reservations—and it scaledHow we used SKIP LOCKED, composite primary keys, and connection visibility to hit our scale targets. During checkout, when a buyer clicks "Complete purchase," we need to guarantee the items they're buying are still available. If...