Every article tagged Transactions, in one place.
Showing 4 articles
Two users buy the last item at the same moment. Without the right transaction design, you sell it twice. These patterns prevent that. Transactions BEGIN; UPDATE accounts SET balance = balance - 500 WHERE id = 1; UPDATE accounts SET balance = balance + 500 WHER...
"Deadlock found when trying to get lock; try restarting transaction" is one of the most common MySQL errors in busy apps. It's not a bug in MySQL; it's two transactions waiting on each other. How a deadlock happens Transaction A Transaction B UPDATE accounts ....
Single-document updates in MongoDB have always been atomic. Since version 4.0 (replica sets) and 4.2 (sharded clusters), MongoDB also supports multi-document ACID transactions. Do you need one? Often a good document design avoids the need. Updating an order an...
Short answer: ACID describes the guarantees a database transaction gives: A tomicity, C onsistency, I solation and D urability. BEGIN; UPDATE accounts SET balance = balance - 1000 WHERE id = 1; UPDATE accounts SET balance = balance + 1000 WHERE id = 2; COMMIT;...
