Re:Shopify replaced Redis with MySQL for inventory reservati...
by dessimus on Sunday August 09, 2026 @01:16PM
(#49233355)
Would a retail business want the inventory to decrement just because users put items into carts that get abandoned? Seems like that would really mess things up more in the long run.
[ Parent
| on HN ]
Re:Shopify replaced Redis with MySQL for inventory reservati...
by derangedHorse on Sunday August 09, 2026 @02:47PM
(#49234341)
An unconfirmed payment might also refer to a credit card charge that is 99% guaranteed to go through but hasn’t completed yet
Re:Shopify replaced Redis with MySQL for inventory reservati...
by resonious on Sunday August 09, 2026 @08:34PM
(#49237855)
Yes. You decrement for a few minutes then release if there's no purchase in time. Airlines figured out how to do this a very long time ago.
Re:Shopify replaced Redis with MySQL for inventory reservati...
by dessimus on Monday August 10, 2026 @11:20AM
(#49244871)
Except airlines, literally oversell flights all the time, and the context of my response was to preventing oversale.
Re:Shopify replaced Redis with MySQL for inventory reservati...
by Breza on Friday August 14, 2026 @10:30AM
(#49299215)
I know this would add complexity, but I wonder if they could train a model to predict the odds of a given cart being abandoned. I'm a data scientist. I bet there are at least a few situations where you could be confident that someone was going to complete a sale.