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
Long-form tutorials and engineering notes on .NET, React, AI/ML, and SaaS architecture.
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.