BestHub
Sign in
Tagged articles
113 articles
Page 2 of 2
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Apr 7, 2017 · Databases

Mastering Final Consistency: Strategies for Distributed Transactions

Ensuring final data consistency in modern applications—whether enterprise or internet—requires understanding ACID, CAP, BASE theories and applying practical techniques such as single-database transactions, two-phase commit, transactional message queues, compensation tasks, async callbacks, and double-check mechanisms to build robust distributed systems.

ACIDBASECAP
0 likes · 8 min read
Mastering Final Consistency: Strategies for Distributed Transactions
Efficient Ops
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
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
ITPUB
ITPUB
Mar 5, 2017 · Databases

Database Transactions Demystified: ACID, Isolation Levels & Spring Propagation

This article explains the fundamental ACID properties of database transactions, details the four isolation levels—READ_UNCOMMITTED, READ_COMMITTED, REPEATABLE_READ, SERIALIZABLE—illustrates common concurrency issues like dirty, non‑repeatable, and phantom reads with examples, and shows how Spring’s transaction propagation and additional features can be leveraged to manage them effectively.

ACIDIsolation Leveldatabase
0 likes · 12 min read
Database Transactions Demystified: ACID, Isolation Levels & Spring Propagation
Architects' Tech Alliance
Architects' Tech Alliance
Nov 25, 2016 · Databases

Why NoSQL Matters: From ACID to CAP and Beyond

An in‑depth overview of NoSQL databases explains the limitations of traditional relational systems, details ACID properties, introduces the CAP theorem and BASE model, compares RDBMS with NoSQL, outlines advantages, disadvantages, history, classifications, and real‑world usage examples.

ACIDBASECAP theorem
0 likes · 12 min read
Why NoSQL Matters: From ACID to CAP and Beyond
Java Backend Technology
Java Backend Technology
Oct 24, 2016 · Databases

Understanding Database Isolation Levels and ACID Properties

This article explains the four MySQL isolation levels, their effects such as dirty reads, non‑repeatable reads and phantom reads, shows how to view and change the isolation level, and reviews the ACID principles of atomicity, consistency, isolation, and durability.

ACIDIsolation Levelmysql
0 likes · 5 min read
Understanding Database Isolation Levels and ACID Properties
ITPUB
ITPUB
Aug 30, 2016 · Databases

How to Build a Distributed KV Store with Full ACID Guarantees

This talk walks through the evolution of databases, explains the challenges of building a distributed key‑value system that provides full ACID properties, and details the architectural components, sharding, migration, snapshot isolation, two‑phase commit, timestamp handling, and distributed transaction processing techniques.

ACIDDistributed SystemsNewSQL
0 likes · 13 min read
How to Build a Distributed KV Store with Full ACID Guarantees
21CTO
21CTO
Apr 23, 2016 · Databases

Mastering Transaction Isolation Levels in MySQL: From Theory to Practice

This article explains the ACID fundamentals, common concurrency anomalies such as dirty, non‑repeatable and phantom reads, the four SQL‑standard isolation levels, how MySQL implements them, and step‑by‑step command‑line tests demonstrating their effects on real transactions.

ACIDconcurrencymysql
0 likes · 10 min read
Mastering Transaction Isolation Levels in MySQL: From Theory to Practice
ITPUB
ITPUB
Nov 10, 2015 · Databases

Inside PostgreSQL: How Its Three‑Layer Transaction Model Works

PostgreSQL implements transactions through a three‑layer architecture—top, middle, and bottom—where the top layer handles user‑visible commands, the middle layer processes statement‑level actions, and the bottom layer manages low‑level atomic operations, each with specific functions and state handling.

ACIDDatabase ArchitecturePostgreSQL
0 likes · 7 min read
Inside PostgreSQL: How Its Three‑Layer Transaction Model Works