ACID | BestHub

Collection size

59 articles

Page 2 of 3

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 TransactionsIsolation Levels

0 likes · 10 min read

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

Full-Stack Internet Architecture

Jun 2, 2021 · Databases

Understanding Database Transaction Isolation Levels and MySQL Experiments

This article explains the concept of database transactions, the ACID properties, MySQL's four isolation levels, the phenomena they cause such as dirty reads, non‑repeatable reads and phantom reads, and provides step‑by‑step experiments demonstrating each isolation level in practice.

ACIDDatabaseIsolation Level

0 likes · 10 min read

Understanding Database Transaction Isolation Levels and MySQL Experiments

Full-Stack Internet Architecture

Jun 18, 2018 · Databases

Understanding the CAP Theorem: Consistency, Availability, and Partition Tolerance

The article explains the CAP theorem, its three properties—consistency, availability, and partition tolerance—how they influence database design, compares CA, CP, and AP classifications with examples, and discusses related concepts such as ACID, BASE, and practical design choices for distributed systems.

ACIDBASECAP theorem

0 likes · 6 min read

Understanding the CAP Theorem: Consistency, Availability, and Partition Tolerance

Mike Chen's Internet Architecture

Apr 8, 2023 · Fundamentals

Understanding Distributed Consistency: CAP, BASE, and Consistency Models

This article explains the fundamentals of distributed consistency, covering strong, weak, and eventual consistency, the CAP theorem, BASE model, and how ACID principles relate to modern distributed systems, helping engineers balance availability and data integrity in large‑scale architectures.

ACIDBASE modelCAP theorem

0 likes · 9 min read

Understanding Distributed Consistency: CAP, BASE, and Consistency Models

Architect's Guide

Apr 20, 2024 · Databases

Why Transaction Isolation Is Needed and an Overview of MySQL Isolation Levels

The article explains why transaction isolation is essential in databases, describes common concurrency problems such as lost updates, dirty reads, non‑repeatable reads, and phantom reads, and outlines MySQL's four isolation levels with their effects and trade‑offs.

ACIDDatabase ConcurrencyIsolation Levels

0 likes · 8 min read

Why Transaction Isolation Is Needed and an Overview of MySQL Isolation Levels

Architect's Guide

Dec 8, 2023 · Databases

Why Transaction Isolation Is Needed and Understanding MySQL Isolation Levels

Transaction isolation prevents concurrency issues such as dirty writes, dirty reads, non‑repeatable reads, and phantom reads in MySQL, and the article explains these problems, the ACID properties of transactions, and the four isolation levels—read uncommitted, read committed, repeatable read, and serializable.

ACIDDatabasesMySQL

0 likes · 9 min read

Why Transaction Isolation Is Needed and Understanding MySQL Isolation Levels

Architect's Guide

Jul 30, 2022 · Databases

Understanding Distributed Transactions, Consistency Models, Sharding, and Commit Protocols

This article explains the fundamentals of distributed transactions, including ACID properties, consistency models, sharding strategies, and the two‑phase, three‑phase, and TCC protocols, while discussing CAP and BASE theories and the challenges of implementing reliable distributed databases.

ACIDBASECAP

0 likes · 23 min read

Understanding Distributed Transactions, Consistency Models, Sharding, and Commit Protocols

IT Xianyu

Dec 2, 2022 · Databases

How MySQL InnoDB Implements ACID: Locks, MVCC, and Logging

This article explains how MySQL's InnoDB engine guarantees ACID properties by describing the four components of ACID, the four isolation levels, lock granularity and types, the MVCC mechanism with version chains and read views, and the roles of undo, redo, and bin logs in ensuring atomicity, consistency, isolation, and durability.

ACIDInnoDBLock

0 likes · 14 min read

How MySQL InnoDB Implements ACID: Locks, MVCC, and Logging

Java Captain

May 25, 2025 · Databases

Database Transactions: ACID Properties, Isolation Levels, and Usage in MySQL

This article provides a comprehensive overview of database transactions, explaining ACID properties, transaction states, explicit and implicit transaction control, isolation levels, and how to configure and use them in MySQL with practical SQL examples and code snippets.

ACIDDatabaseIsolation Level

0 likes · 22 min read

Database Transactions: ACID Properties, Isolation Levels, and Usage in MySQL

Xiaokun's Architecture Exploration Notes

Jun 12, 2020 · Fundamentals

Master Distributed System Consistency: CAP, ACID, BASE & Transaction Protocols

This article explains core distributed‑system concepts—including the CAP theorem, ACID and BASE models, consistency guarantees, and the mechanics of 2PC, 3PC, and TCC transaction protocols—while also discussing availability strategies and practical design considerations.

ACIDBASECAP theorem

0 likes · 19 min read

Master Distributed System Consistency: CAP, ACID, BASE & Transaction Protocols

Architecture & Thinking

Nov 17, 2023 · Databases

Mastering MySQL Transactions: ACID, Isolation Levels, and Common Pitfalls

This article explains MySQL transaction fundamentals, the necessity of ACID properties, details the four isolation levels and their impact on phenomena like dirty reads, non‑repeatable reads, and phantom reads, and provides practical SQL examples and strategies for ensuring data consistency in high‑concurrency environments.

ACIDDatabase ConcurrencyInnoDB

0 likes · 15 min read

Mastering MySQL Transactions: ACID, Isolation Levels, and Common Pitfalls

Spring Full-Stack Practical Cases

Jun 25, 2023 · Databases

Master MySQL Transactions: ACID, Isolation Levels, and Practical Commands

This guide explains MySQL transaction fundamentals, the ACID properties, how to use explicit and implicit transactions, savepoints, and demonstrates each isolation level with commands and examples to help developers write reliable, concurrent database code.

ACIDIsolation LevelsMySQL

0 likes · 12 min read

Master MySQL Transactions: ACID, Isolation Levels, and Practical Commands

Efficient Ops

Apr 6, 2017 · Fundamentals

Mastering Distributed Consistency: Real‑World Patterns and Protocols

This article examines the challenges of consistency in large‑scale distributed service systems, presents real‑world case studies such as payment transfers and order processing, and outlines practical patterns—including ACID/BASE theory, two‑phase and three‑phase commit, TCC, query, compensation, periodic reconciliation, and reliable messaging—to help engineers design robust, eventually consistent architectures.

ACIDBASECAP theorem

0 likes · 39 min read

Mastering Distributed Consistency: Real‑World Patterns and Protocols

Beike Product & Technology

Jun 1, 2018 · Databases

InnoDB Transaction and Index Principles

This article explains InnoDB's transaction and index principles, covering ACID properties, transaction logs, MVCC, locking mechanisms, and B+ tree index structures to help backend developers understand how InnoDB ensures data consistency and high concurrency.

ACIDB+TreeIndex Optimization

0 likes · 11 min read

JD Tech Talk

Oct 24, 2019 · Databases

JDTX Distributed Transaction Solution: Design Principles, Features, and Implementation Challenges

This article introduces JDTX, a high‑performance, ACID‑compliant distributed transaction middleware, explains its architecture based on WAL and MVCC, compares rigid two‑phase commit and flexible BASE‑based approaches, and discusses the technical difficulties and future roadmap for integrating JDTX with Apache ShardingSphere and cloud‑native platforms.

ACIDDistributed TransactionsJDTX

0 likes · 15 min read

JDTX Distributed Transaction Solution: Design Principles, Features, and Implementation Challenges

Qunar Tech Salon

Jul 26, 2017 · Databases

Understanding Distributed System Consistency, CAP, ACID, and Transaction Protocols (2PC & 3PC)

This article explains the challenges of consistency in distributed systems, introduces the CAP theorem and ACID properties, describes common distributed transaction techniques such as local message tables, transactional message middleware like RocketMQ, and details the two‑phase and three‑phase commit protocols with their advantages and drawbacks.

2PC3PCACID

0 likes · 16 min read

Understanding Distributed System Consistency, CAP, ACID, and Transaction Protocols (2PC & 3PC)

AntTech

Oct 7, 2019 · Databases

OceanBase’s TPC‑C Benchmark: Technical Deep Dive into Test Preparation, System Architecture, and Performance Results

This article provides a comprehensive technical analysis of OceanBase’s record‑breaking TPC‑C benchmark, covering the preparation work, test system design, planning, performance testing methodology, ACID verification, and the lessons learned from achieving 60.88 million tpmC on a distributed cloud platform.

ACIDDatabase BenchmarkDistributed Database

0 likes · 12 min read

OceanBase’s TPC‑C Benchmark: Technical Deep Dive into Test Preparation, System Architecture, and Performance Results

AntTech

May 28, 2018 · Databases

Understanding Distributed Transactions: Concepts, XA Protocol, and TCC Model

This article introduces the fundamentals of distributed transactions, explains the ACID properties of transactions, compares local and distributed transaction architectures, and provides detailed analyses of two common distributed transaction models—X/Open XA and TCC—including their atomicity, isolation, consistency mechanisms and practical trade‑offs.

ACIDDistributed TransactionsTCC model

0 likes · 20 min read

Understanding Distributed Transactions: Concepts, XA Protocol, and TCC Model

IT Architects Alliance

Feb 17, 2022 · Databases

Understanding Consistency in Distributed Transactions: Strong vs. Weak, CAP Theory, and NewSQL Approaches

This article explains the concept of consistency in distributed transactions, compares strong and weak consistency, relates it to the CAP theorem, and explores theoretical and practical approaches—including XA, NewSQL, and MVCC—to achieve stronger consistency across databases and micro‑services.

ACIDCAP theoremDistributed Transactions

0 likes · 13 min read

Understanding Consistency in Distributed Transactions: Strong vs. Weak, CAP Theory, and NewSQL Approaches

Architects' Tech Alliance

Sep 11, 2018 · Databases

Understanding Distributed Transactions: Principles, 2PC, 3PC, XA, Saga, and Message‑Based Approaches

This article explains the fundamentals of database transactions, the ACID properties, and how they are implemented, then delves into distributed transaction challenges and solutions such as two‑phase and three‑phase commit, XA, Saga patterns, choreography vs. orchestration, and message‑based transaction mechanisms.

2PC3PCACID

0 likes · 16 min read

Understanding Distributed Transactions: Principles, 2PC, 3PC, XA, Saga, and Message‑Based Approaches