Inventory Reservations at Scale: Why Shopify Moved from Redis to MySQL
Deep dive into high-concurrency inventory reservation architectures — why Redis dual-writes cause overselling and underselling, how MySQL 8 SKIP LOCKED eliminates row contention, and how Shopify scaled to $5.1M GMV/minute during Black Friday.