Shopify 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.
339 points by adletbalzhanov 74 days ago shopify.engineering 251 comments

Summary

Shopify shares their experience of replacing Redis with MySQL for inventory reservations, detailing their use of SKIP LOCKED, composite primary keys, and connection visibility to achieve significant scalability. Learn about the technical strategies that enabled this transition.

Comments (251 of ) ⌛

Loading more comments... ⌛
Scroll down to load more comments
No comments available.
Type to search HN and engineering blog articles
Press Escape to close  |  ↑↓ to navigate  |  Enter to open