Posts tagged "mysql"

Coordinate two transactions to create a real lock cycle, then retry whole transactions with a limit and use a consistent row order.

Reserve stock with a conditional update, keep the order in the same InnoDB transaction, and check the rollback paths.