Optimistic or pessimistic locking: measured on a 100-seat booking
Pessimistic locking, optimistic locking (version), conditional updates and a Redis lock with a fencing token, measured on a 100-seat flight with 400 concurrent requests on MySQL 8.4: which are correct, which are fast, which turn people away for no reason; plus locking best practices and the four conditions for deadlock.