Articles tagged with #Transactions
A curated list of engineering series, deep dives, and notes related to #Transactions.
Building a Custom Transactional Storage Engine in Java: The Database Capstone
Build a complete, working transactional storage engine in Java with slotted memory pages, WAL crash recovery, LRU buffer pool management, and 2PL locking.
Declarative Transaction Management: How @Transactional Works Under the Hood
Understand Spring's @Transactional internal mechanics: TransactionInterceptor proxying, PlatformTransactionManager, propagation levels, and silent rollback failures.
Kafka Exactly-Once Semantics (EOS): Idempotent Producers & 2PC Transactions
Learn how Kafka achieves Exactly-Once Semantics (EOS) across read-process-write stream loops using Idempotent Producers, Transactional Coordinators, and 2PC.
Multi-Version Concurrency Control (MVCC): How Non-Blocking Snapshot Reads Work
Learn how modern databases like MySQL InnoDB implement Multi-Version Concurrency Control (MVCC) to achieve non-blocking snapshot reads using DB_TRX_ID and roll pointers.
Database Concurrency Anomalies: Dirty Reads, Non-Repeatable Reads, Phantoms & Lost Updates
Explore database concurrency anomalies including dirty reads, non-repeatable reads, phantom reads, and lost updates, with interleaved transaction timelines.
Distributed Transactions: Two-Phase Commit (2PC) vs The Saga Pattern
Master distributed transactions. Compare Two-Phase Commit (2PC) blocking mechanics with Saga Pattern choreography, orchestration, and compensating actions.
Demystifying ACID: Transactions as an Isolation & Recovery Abstraction
Deconstruct ACID transaction guarantees in database engines. Learn how atomicity, consistency, isolation, and durability function under the hood.