We replaced Redis with MySQL for inventory reservations—and it scaled

We replaced Redis with MySQL for inventory reservations—and it scaled

摘要

Shopify将库存预留系统从Redis迁移至MySQL，利用SKIP LOCKED和每单位一行设计应对高并发。实际瓶颈并非数据库，而是连接池被其他进程耗尽。通过清理冗余操作和调整配置，最终实现稳定支撑黑五峰值流量。