Tag: Transaction
16 articles
MySQL Transaction and Lock Mechanism: ACID Properties
ACID properties: atomicity, consistency, isolation, durability, WAL mechanism.
MySQL Undo/Redo Log: Transaction Rollback and Persistence
Undo Log for rollback, Redo Log for redo, transaction atomicity, durability, MVCC.
Distributed Services ACID: Three-Phase Commit 3PC vs 2PC
This article provides an in-depth analysis of the Three-Phase Commit protocol (3PC) and its differences from Two-Phase Commit (2PC) in distributed transaction processing.
Distributed Services ACID: Two-Phase Commit 2PC Protocol
This article provides an in-depth analysis of the Two-Phase Commit protocol (2PC) for distributed transactions, covering ACID properties and practical implementation.
Spring In-Depth: Declarative Transaction Support, XML and XML+Annotation Modes
In-depth guide to Spring declarative transaction support covering transaction configuration with XML mode and XML+annotation mode with practical examples.
Spring In-Depth: Declarative Transaction Support, Transaction Control and Isolation Levels
In-depth introduction to Spring declarative transaction support covering transaction control, concepts, four characteristics, and isolation levels with practical examples.
Neo4j Transaction, Index and Constraint Practice: Syntax, Concurrency and Troubleshooting
Neo4j transaction handling, index creation, constraint settings and concurrency issue troubleshooting.
MySQL Transactions: ACID Properties, Isolation Levels and Use Cases
MySQL database transaction is a set of SQL operations executed as a single logical unit of work, following ACID principles: Atomicity, Consistency, Isolation and Durabili...
MySQL Transaction Issues: Dirty Read, Non-Repeatable Read and Phantom Read
Common issues in database transactions include dirty read, non-repeatable read, and phantom read. These issues are closely related to database isolation levels.
Spring Boot Transaction Propagation: From REQUIRED to NESTED
Transaction propagation is an important mechanism in Spring for handling transaction boundaries, defining how methods interact with transaction context in the call chain.
Spring Boot Declarative vs Programmatic Transactions
Introduces declarative transaction and programmatic transaction concepts, usage methods and comparative analysis.
Spring Transaction Pitfalls Part 2: Common Issues and Solutions
Spring transactions are implemented through AOP dynamic proxies. JDK dynamic proxy requires the target method to be public.
Spring Boot @Transactional: Propagation, Isolation and Rollback Rules
Detailed introduction to @Transactional annotation parameters in Spring Boot, including transaction propagation, isolation levels, and exception rollback strategies.
Spring Transaction Pitfalls Part 1: Common Issues and Solutions
Spring transaction pitfalls commonly occur in scenarios like classes not managed by Spring, transaction manager not started, improper method modifiers (final, static...
Spring Transaction Pitfalls Part 3: Common Issues and Solutions
Spring transaction pitfalls include rollbackFor configuration errors, transaction annotation overrides, nested transaction issues and more.
Spring Transaction Pitfalls Part 4: Multi-Threading and Exception Handling
Spring transaction pitfalls include multi-threaded calls, exception catching without rollback, manual exception throwing errors.