Shopify replaced Redis with MySQL for inventory reservations–and it scaled

How we used SKIP LOCKED, composite primary keys, and connection visibility to hit our scale targets.