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

How we used SKIP LOCKED, composite primary keys, and connection visibility to hit our scale targets.