SQL
How We Replaced Redis with MySQL SKIP LOCKED for Inventory Reservation at Scale
How Mattrx ended oversells and retired a Redis cluster by moving inventory reservation into MySQL with SELECT FOR UPDATE SKIP LOCKED.
23 min read40
Query design, indexing, transactions, and tuning.
2 posts · 8 questions
How Mattrx ended oversells and retired a Redis cluster by moving inventory reservation into MySQL with SELECT FOR UPDATE SKIP LOCKED.
B-tree, BRIN, GIN, partial, covering. Which to use when, with explain plans you can copy.