BestHub
search
Sign in
Topic

ACID

Collection size
59 articles
Page 1 of 3
DaTaobao Tech
DaTaobao Tech
Aug 15, 2022 · Cloud Native

Reflections on CAP Theory, ACID, BASE, and Cloud‑Native Fault Tolerance

Reflecting on reading, the author reviews CAP theory’s consistency‑availability‑partition trade‑offs, extends ACID and BASE concepts, proposes modernizing CAP objects to consistency, fault and disaster tolerance, and examines how cloud‑native architectures, micro‑services, and SLA‑driven designs reshape fault tolerance and future self‑healing systems.

ACIDBASECAP theorem
0 likes · 21 min read
Reflections on CAP Theory, ACID, BASE, and Cloud‑Native Fault Tolerance
JD Retail Technology
JD Retail Technology
Jun 30, 2023 · Fundamentals

Fundamentals of Distributed Systems: CAP Theory, ACID, BASE, Idempotency, and Distributed Transaction Protocols

This article explains core distributed‑system concepts such as the CAP theorem, ACID and BASE transaction models, idempotent design, and various distributed transaction mechanisms including two‑phase and three‑phase commit, TCC/Saga compensation, message‑based transactions, and popular frameworks like JDTS and Seata.

2PC3PCACID
0 likes · 6 min read
Fundamentals of Distributed Systems: CAP Theory, ACID, BASE, Idempotency, and Distributed Transaction Protocols
JD Retail Technology
JD Retail Technology
Jul 12, 2019 · Databases

Understanding MySQL Lock Mechanisms, Transaction Isolation, and Concurrency Control

This article explains MySQL's lock types—including table and row locks, InnoDB's shared, exclusive, and intention locks—covers lock algorithms such as record, gap, next‑key, and insert‑intention locks, discusses deadlock and blocking issues, and details transaction management, isolation levels, and related configuration parameters.

ACIDConcurrencyInnoDB
0 likes · 39 min read
Understanding MySQL Lock Mechanisms, Transaction Isolation, and Concurrency Control
政采云技术
政采云技术
Jul 18, 2023 · Databases

Transaction Overview and Implementation Strategies: Database, Spring, and Distributed Solutions

This article explains the ACID properties of transactions and compares various implementation approaches—including database‑level mechanisms, Spring single‑datasource transactions, and distributed transaction frameworks such as Seata and RocketMQ—while analyzing their advantages, drawbacks, and suitable scenarios.

ACIDDatabaseRocketMQ
0 likes · 9 min read
Transaction Overview and Implementation Strategies: Database, Spring, and Distributed Solutions
Zhuanzhuan Tech
Zhuanzhuan Tech
Dec 13, 2024 · Databases

Understanding MySQL Architecture and Log Mechanisms for ACID Transactions

This article provides a comprehensive overview of MySQL's layered architecture, the functions and core components of the server layer, and detailed explanations of Undo Log, Redo Log, and Binlog mechanisms that together ensure the ACID properties of transactions, including practical execution flows for queries and updates.

ACIDBinlogDatabase Architecture
0 likes · 29 min read
Understanding MySQL Architecture and Log Mechanisms for ACID Transactions
Wukong Talks Architecture
Wukong Talks Architecture
Dec 30, 2020 · Fundamentals

Understanding CAP, ACID, and BASE Theories Through the Metaphor of Tai Chi and Distributed Systems

This article uses the story of Tai Chi from the novel *The Heaven Sword and Dragon Saber* to explain the CAP theorem, ACID properties, BASE theory, and two‑phase commit in distributed systems, illustrating how consistency, availability, and partition tolerance correspond to the hard and soft aspects of Tai Chi.

ACIDBASECAP
0 likes · 14 min read
Understanding CAP, ACID, and BASE Theories Through the Metaphor of Tai Chi and Distributed Systems
Big Data Technology Architecture
Big Data Technology Architecture
Nov 5, 2021 · Databases

Snowflake and Delta Lake: Architecture, Features, and Comparative Analysis

This article provides a comprehensive overview of Snowflake and Delta Lake, detailing their cloud‑native architectures, storage‑compute separation, transaction support, performance optimizations, and a side‑by‑side comparison of their capabilities, openness, and real‑time data handling.

ACIDCloud ArchitectureData Warehouse
0 likes · 25 min read
Snowflake and Delta Lake: Architecture, Features, and Comparative Analysis
Big Data Technology Architecture
Big Data Technology Architecture
Apr 5, 2021 · Big Data

Understanding Apache Iceberg: Table Format Architecture, Comparison with Hive Metastore, and Business Benefits

This article introduces Apache Iceberg as an open table format for massive analytic datasets, explains its underlying concepts such as schema, partitioning, statistics, and read/write APIs, compares it with Hive Metastore, outlines its ACID commit process, highlights the performance and operational advantages for big‑data workloads, and previews upcoming community features.

ACIDApache IcebergData Lake
0 likes · 19 min read
Understanding Apache Iceberg: Table Format Architecture, Comparison with Hive Metastore, and Business Benefits
Laravel Tech Community
Laravel Tech Community
Dec 7, 2022 · Databases

Understanding Transaction Isolation and Concurrency Issues in Databases

The article explains why transaction isolation is required, 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 on data consistency.

ACIDConcurrencyDatabase
0 likes · 8 min read
Understanding Transaction Isolation and Concurrency Issues in Databases
IT Architects Alliance
IT Architects Alliance
Dec 25, 2022 · Databases

Understanding Database Transactions, ACID Principles, and Spring @Transactional Behavior

This article explains the importance of data safety, defines the ACID properties of transactions, details how InnoDB implements them, and shows how Spring's @Transactional annotation works with AOP, including default rollback behavior, configuration options, and common pitfalls that can cause transaction failures.

ACIDDatabaseJava
0 likes · 9 min read
Understanding Database Transactions, ACID Principles, and Spring @Transactional Behavior
IT Architects Alliance
IT Architects Alliance
Apr 22, 2022 · Databases

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

This article explains the fundamentals of distributed transactions, the ACID properties, various consistency models, database sharding strategies, and the two‑phase, three‑phase, and TCC commit protocols, while also discussing CAP, BASE, and practical challenges in large‑scale systems.

ACIDCAPSharding
0 likes · 22 min read
Understanding Distributed Transactions, Consistency Models, Sharding, and Commit Protocols
IT Architects Alliance
IT Architects Alliance
Mar 9, 2022 · Databases

Understanding Database Transactions, ACID Properties, and Two‑Phase/Three‑Phase Commit Protocols

This article explains the ACID properties of database transactions, distinguishes between single‑node and distributed transactions, describes the two‑phase and three‑phase commit protocols, discusses transaction states, fault tolerance, and recovery mechanisms, and shows how replication and consensus can provide high availability for transaction processing.

2PC3PCACID
0 likes · 10 min read
Understanding Database Transactions, ACID Properties, and Two‑Phase/Three‑Phase Commit Protocols
Architecture Digest
Architecture Digest
Apr 7, 2022 · Databases

Understanding Distributed Transactions, Consistency Models, and Commit Protocols

This article explains the fundamentals of distributed transactions, covering ACID properties, consistency models, sharding strategies, CAP and BASE theories, and compares two‑phase, three‑phase, and TCC commit protocols to illustrate how modern systems maintain data integrity across multiple nodes.

ACIDShardingTwo-Phase Commit
0 likes · 21 min read
Understanding Distributed Transactions, Consistency Models, and Commit Protocols
Architecture Digest
Architecture Digest
Aug 9, 2018 · Databases

Understanding Database Transactions: ACID, Distributed Transactions, and Common Solutions

This article explains the fundamentals of database transactions, the ACID properties, the challenges of distributed transactions, and compares various solutions such as 2PC, TCC, local message tables, MQ transactions, and Saga, helping readers choose appropriate approaches based on consistency and availability requirements.

2PCACIDCAP
0 likes · 17 min read
Understanding Database Transactions: ACID, Distributed Transactions, and Common Solutions
Architecture Digest
Architecture Digest
Apr 6, 2017 · Fundamentals

Distributed Service System Consistency: Best Practices and Patterns

This article examines the challenges of achieving consistency in large‑scale distributed service systems, outlines common inconsistency scenarios such as split‑brain and lost updates, and presents practical patterns—including ACID/BASE trade‑offs, two‑phase and three‑phase commit, TCC, query, compensation, and reliable messaging—to guide engineers in designing robust, eventually consistent architectures.

ACIDBASEconsistency
0 likes · 35 min read
Distributed Service System Consistency: Best Practices and Patterns
FunTester
FunTester
Nov 8, 2022 · Databases

Comprehensive Guide to Database Testing: Concepts, Techniques, and Best Practices

Database testing ensures data integrity, security, and quality by validating data mapping, ACID properties, schema, triggers, stored procedures, and field constraints through both manual and automated methods, using SQL queries, CRUD operations, and specialized tools to verify that applications interact correctly with underlying databases.

ACIDAutomationData Integrity
0 likes · 13 min read
Comprehensive Guide to Database Testing: Concepts, Techniques, and Best Practices
Java Tech Enthusiast
Java Tech Enthusiast
May 23, 2025 · Databases

MySQL Indexes, ACID, Raft, and gRPC: Technical Interview Insights

This article combines a Meituan salary update with detailed explanations of MySQL indexing strategies, B‑tree variations, ACID transaction properties, isolation levels, caching, handling high‑traffic queries, the Raft consensus algorithm, and an overview of gRPC, providing comprehensive backend development knowledge for interview preparation.

ACIDDatabaseIndexes
0 likes · 17 min read
MySQL Indexes, ACID, Raft, and gRPC: Technical Interview Insights
Top Architect
Top Architect
Dec 26, 2022 · Databases

Understanding Transaction Isolation and Concurrency Issues in MySQL

The article explains why transaction isolation is needed, describes common concurrency problems such as lost updates, dirty reads, non‑repeatable reads and phantom reads, outlines the ACID properties of a transaction, and details MySQL's four isolation levels and their impact on data consistency.

ACIDDatabaseMySQL
0 likes · 8 min read
Understanding Transaction Isolation and Concurrency Issues in MySQL
Top Architect
Top Architect
Oct 13, 2022 · Databases

Understanding Transaction Isolation Levels and Concurrency Issues in MySQL

The article explains why transaction isolation is needed, describes common concurrency problems such as lost updates, dirty reads, non‑repeatable reads and phantom reads, outlines the ACID properties of a transaction, and details MySQL's four isolation levels with their effects and default settings.

ACIDConcurrencyDatabase
0 likes · 8 min read
Understanding Transaction Isolation Levels and Concurrency Issues in MySQL