Mastering Data Consistency: Transactions, Isolation Levels, and MVCC Explained

This article explores how to achieve data consistency by examining transaction properties, isolation levels, common concurrency issues like dirty, non-repeatable, and phantom reads, and compares lock‑based concurrency control with multi‑version concurrency control (MVCC), detailing undo logs, read‑view mechanisms, and practical examples.

ConsistencyMVCCTransactions

0 likes · 15 min read

Mastering Data Consistency: Transactions, Isolation Levels, and MVCC Explained

Full-Stack Internet Architecture

Oct 13, 2021 · Databases

Understanding Database Transactions, ACID Properties, Isolation Levels, and Spring Transaction Management

This article explains the concept of database transactions, the ACID properties, various isolation levels, and how Spring Framework implements transaction propagation, isolation, and architecture, providing both theoretical background and practical guidance for developers.

ACIDTransactionsisolation-levels

0 likes · 10 min read

Understanding Database Transactions, ACID Properties, Isolation Levels, and Spring Transaction Management

Full-Stack Internet Architecture

Dec 19, 2020 · Databases

Understanding Transaction Fundamentals: ACID, Isolation Levels, Spring Transaction Propagation, and Distributed Transaction CAP Theory

This article explains the core concepts of database transactions—including ACID properties, common concurrency anomalies, MySQL isolation levels, Spring's isolation and propagation settings, and the CAP theorem's impact on distributed transactions—providing a comprehensive overview for developers and engineers.

ACIDdistributed-systemsisolation-levels

0 likes · 8 min read

Understanding Transaction Fundamentals: ACID, Isolation Levels, Spring Transaction Propagation, and Distributed Transaction CAP Theory