Tagged articles

Database Transactions

14 articles · Page 1 of 1

Sep 27, 2026 · Backend Development

Why the 101st Waitlist User Never Gets Skipped: Atomic Promotion with MySQL Row Locks

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.

Database TransactionsInnoDBJava 17

0 likes · 12 min read

Why the 101st Waitlist User Never Gets Skipped: Atomic Promotion with MySQL Row Locks

liandk

Aug 22, 2026 · Databases

Mastering Database Transactions: Eliminate Data Chaos and Loss with ACID Basics

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 ConsistencyDatabase Transactions

0 likes · 6 min read

Mastering Database Transactions: Eliminate Data Chaos and Loss with ACID Basics

liandk

Jul 31, 2026 · Databases

Why Transactions Are Essential: Master ACID, Isolation Levels, and Prevent Dirty/Phantom Reads

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.

ACIDDatabase TransactionsDirty Read

0 likes · 7 min read

Why Transactions Are Essential: Master ACID, Isolation Levels, and Prevent Dirty/Phantom Reads

YiSu Grain

Jul 8, 2026 · Databases

Why a Transfer Can’t Just Deduct Money – A Simple Guide to ACID Transactions

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.

ACIDDatabase TransactionsMySQL

0 likes · 8 min read

Why a Transfer Can’t Just Deduct Money – A Simple Guide to ACID Transactions

Senior Brother's Insights

Oct 31, 2025 · Databases

Master MySQL Transactions: ACID, Locks, and Practical Examples

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.

ACIDDatabase TransactionsInnoDB

0 likes · 12 min read

Master MySQL Transactions: ACID, Locks, and Practical Examples

Senior Brother's Insights

Oct 27, 2025 · Databases

How Does MySQL Power High‑Performance OLTP Workloads?

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.

Database TransactionsIndexingInnoDB

0 likes · 9 min read

How Does MySQL Power High‑Performance OLTP Workloads?

Full-Stack Internet Architecture

Nov 27, 2024 · Databases

Understanding MySQL Database Transactions: ACID Properties, Control Statements, and Isolation Levels

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.

ACIDDatabase TransactionsMySQL

0 likes · 10 min read

Understanding MySQL Database Transactions: ACID Properties, Control Statements, and Isolation Levels

Architect's Tech Stack

May 17, 2024 · Databases

Understanding MySQL SELECT ... FOR UPDATE Locking: Row vs. Table Locks

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.

Database TransactionsMySQLRow Lock

0 likes · 4 min read

Understanding MySQL SELECT ... FOR UPDATE Locking: Row vs. Table Locks

Full-Stack Internet Architecture

Oct 28, 2023 · Databases

Understanding Database Transactions and MySQL Transaction Control

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.

ACIDDatabase TransactionsMySQL

0 likes · 7 min read

Understanding Database Transactions and MySQL Transaction Control

Laravel Tech Community

Jun 22, 2022 · Databases

Understanding MySQL SELECT ... FOR UPDATE: When It Locks Rows vs. Tables

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.

Database TransactionsMySQLRow Lock

0 likes · 4 min read

Understanding MySQL SELECT ... FOR UPDATE: When It Locks Rows vs. Tables

High Availability Architecture

Sep 20, 2019 · Backend Development

Ensuring Idempotency and Preventing Double Payments in a Distributed Payments System

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.

Database TransactionsJavaPayments

0 likes · 19 min read

Ensuring Idempotency and Preventing Double Payments in a Distributed Payments System

AntTech

Aug 7, 2018 · Databases

A Timeline Review of Optimistic Concurrency Control (OCC) from Theory to Production Systems

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.

Database TransactionsNewSQLOCC

0 likes · 33 min read

A Timeline Review of Optimistic Concurrency Control (OCC) from Theory to Production Systems

Tencent IMWeb Frontend Team

Jun 16, 2016 · Backend Development

Mastering Database Transactions in Node.js with Bookshelf.js ORM

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.jsDatabase Transactions

0 likes · 6 min read

Mastering Database Transactions in Node.js with Bookshelf.js ORM

Architecture Digest

May 18, 2016 · Backend Development

Understanding Atomic Operations, Thread Synchronization, and Data Consistency in High‑Concurrency Java Systems

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.

AtomicityConcurrencyDatabase Transactions

0 likes · 20 min read

Understanding Atomic Operations, Thread Synchronization, and Data Consistency in High‑Concurrency Java Systems