Shopify replaced Redis with MySQL for inventory reservations — and it scaled
Shopify's oversell protection — the short hold that keeps two checkouts from claiming the last unit — ran on Redis for years, and earlier attempts to move it to MySQL died on row contention. MySQL 8's SKIP LOCKED let them flip the model to one row per inventory unit instead of one row per item, and it held through Black Friday peaks of $5.1M in sales per minute.