Skip to content
Tagged articles

database transactions

15 articles · Page 1 of 1
Internet Backend Architecture Stack
Internet Backend Architecture Stack
Oct 14, 2026 · Backend Development

Async Idempotency in Practice: Local Message Tables, Duplicate Deduction Fixes, and Layered Defense

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
Async Idempotency in Practice: Local Message Tables, Duplicate Deduction Fixes, and Layered Defense
liandk
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 ConsistencySQL
0 likes · 6 min read
Mastering Database Transactions: Eliminate Data Chaos and Loss with ACID Basics
YiSu Grain
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.

ACIDMySQLconcurrency control
0 likes · 8 min read
Why a Transfer Can’t Just Deduct Money – A Simple Guide to ACID Transactions
Senior Brother's Insights
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.

ACIDInnoDBLocks
0 likes · 12 min read
Master MySQL Transactions: ACID, Locks, and Practical Examples
Senior Brother's Insights
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.

High AvailabilityIndexingInnoDB
0 likes · 9 min read
How Does MySQL Power High‑Performance OLTP Workloads?
AntTech
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.

NewSQLOCCconcurrency control
0 likes · 33 min read
A Timeline Review of Optimistic Concurrency Control (OCC) from Theory to Production Systems