flâneur

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

shopify.engineering · 2,161 words · saved by 1 readers

How 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 we get this wrong in one direction, two buyers purchase the same last unit: the merchant has to cancel an order, send an apology email, and eat the support cost. If we get it wrong in the other direction, we tell a buyer something is sold out when it isn't, and the merchant loses a sale they should have made. At Shopify's scale, either failure compounds fast. On Black Friday 2025, merchants on our platform hit a record $5.1 million in sales per minute at peak.…

saved by

related reading