Tagged articles
database transactions
15 articles · Page 1 of 1
A real-world postmortem of duplicate coupon deductions during a major promotion reveals how retries in local message tables cause duplicate execution; the article dissects four idempotency patterns, their trade-offs, and a layered defense architecture with a practical review checklist.
Architecture PatternsIdempotencydatabase transactions
0 likes · 24 min read

This article demonstrates how to implement a correct waitlist auto-promotion system for limited-capacity events using Spring Boot, MySQL InnoDB row locks, and database transactions to atomically handle cancellations and promotions without race conditions, ensuring the first waitlisted user always gets the freed spot.
InnoDBJava 17MySQL
0 likes · 12 min read


liandkAug 22, 2026 · Databases
The article explains how database transactions ensure atomicity, consistency, isolation, and durability, showing why they are essential for preventing data inconsistency, loss, and reconciliation errors, and provides step‑by‑step SQL examples of successful and rolled‑back transactions along with practical tips for safe usage.
ACIDData ConsistencySQL
0 likes · 6 min read


liandkJul 31, 2026 · Databases
This article explains why database transactions are a core backend skill, breaks down the four ACID properties, clarifies dirty read, non‑repeatable read and phantom read, compares the four isolation levels, and offers practical guidelines for choosing the right level in production.
ACIDDirty ReadMySQL
0 likes · 7 min read

The article uses a simple money‑transfer scenario to introduce database transactions, explains the four ACID properties, illustrates common concurrency anomalies such as dirty reads, non‑repeatable reads and phantom reads, and outlines the four isolation levels with their trade‑offs and default settings in MySQL and Oracle.
ACIDMySQLconcurrency control
0 likes · 8 min read

This article explains what database transactions are, why they matter, details MySQL’s transaction commands, the ACID properties, isolation levels, lock types, MVCC, how to use InnoDB, handle errors, employ savepoints, and provides concrete SQL examples for creating, committing, rolling back, and managing transactions.
ACIDInnoDBLocks
0 likes · 12 min read

This article explains what OLTP (Online Transaction Processing) is, outlines its key characteristics, and details how MySQL—through ACID‑compliant transactions, the InnoDB storage engine, various indexing strategies, fast locking mechanisms, query optimization, and high‑availability features—effectively supports high‑concurrency, low‑latency transactional workloads.
High AvailabilityIndexingInnoDB
0 likes · 9 min read

This article explains the concept and importance of MySQL database transactions, describes the ACID properties, shows how to use transaction control statements and savepoints, and demonstrates each isolation level (read uncommitted, read committed, repeatable read, serializable) with practical SQL examples.
ACIDMySQLSQL
0 likes · 10 min read

This article explains how MySQL's SELECT ... FOR UPDATE statement acquires either row-level or table-level locks depending on the presence of indexes or primary keys, and demonstrates the behavior with multiple transaction examples and a sample table definition.
MySQLRow LockSELECT FOR UPDATE
0 likes · 4 min read

This article explains the concept of database transactions, the ACID properties, how MySQL implements transactions with InnoDB, how to manage autocommit, the essential transaction control statements, a practical example using savepoints, and the four isolation levels supported by MySQL.
ACIDMySQLSQL
0 likes · 7 min read

This article explains how a plain SELECT does not lock data, while SELECT … FOR UPDATE adds a pessimistic lock whose scope—row or table—depends on whether the query uses an indexed or primary‑key column, and demonstrates the behavior with SQL examples and transaction scenarios.
MySQLRow LockSELECT FOR UPDATE
0 likes · 4 min read

The article explains how Airbnb’s payment platform uses a generic idempotency library called Orpheus, combined with Java lambda‑driven transaction composition, to guarantee data consistency, avoid double charges, and handle retries in a low‑latency micro‑service architecture.
IdempotencyJavaPayments
0 likes · 19 min read

This article presents a chronological overview of Optimistic Concurrency Control (OCC), covering its early theoretical foundations, key research papers, prototype implementations such as MVCC+OCC+2PC and Hekaton, and its adoption in modern distributed NewSQL databases like Megastore, F1, and MaaT, highlighting both advantages and challenges.
NewSQLOCCconcurrency control
0 likes · 33 min read

This article explains the concept of database transactions, their ACID properties, and provides a step‑by‑step Node.js example using the Bookshelf.js ORM to safely perform multi‑table operations within a transaction.
ACIDBookshelf.jsNode.js
0 likes · 6 min read

This article explains how atomic operations, Java concurrency primitives, database transaction mechanisms, and scalability techniques combine to ensure data consistency and high performance in large‑scale e‑commerce systems under extreme traffic loads.
ConcurrencyJavaatomicity
0 likes · 20 min read
