13. Multi-Document Distributed ACID Transactions with Sessions • MongoDB & NoSQL Architecture: CRUD to Sharding & WiredTiger • Rishabh Ki Kaksha

MongoDB & NoSQL Architecture: CRUD to Sharding & WiredTiger › 13. Multi-Document Distributed ACID Transactions with Sessions

45 mins

← Prev Next →

Course Syllabus

Module 1: MongoDB Foundations, BSON & CRUD Mechanics

01. NoSQL vs SQL: CAP Theorem & Document-Oriented Architecture 02. BSON Data Types & Document Schema Design (Embedding vs Referencing) 03. High-Performance CRUD Operations, BulkWrite & Write Concerns 04. Schema Validation with JSON Schema ($jsonSchema)

Module 2: Advanced Aggregation Framework & Data Pipelines

05. Aggregation Pipeline Core: $match, $project, $group, $sort & $limit 06. Complex Transformations: $unwind, $lookup (Joins) & $facet (Multi-Facet Analytics) 07. Window Operators ($setWindowFields) & Accumulator Functions

Module 3: Indexing Strategies & Query Optimization

08. B-Tree Indexes in MongoDB: Single Field, Compound & Partial Indexes 09. Special Indexes: TTL (Time-To-Live), Geospatial (2dsphere) & Text Indexes 10. Query Profiling, explain("executionStats") & Index Covering Analysis

Module 4: Storage Engine Internals (WiredTiger) & ACID Transactions

11. WiredTiger Storage Engine Architecture: Cache, Compression & Checkpoints 12. Read Concerns (local, majority, linearizable) & Write Concerns (w:majority, j:true) 13. Multi-Document Distributed ACID Transactions with Sessions

Module 5: High Availability, Replica Sets, Sharding & Backups

14. Replica Sets Architecture: Primary Election, Oplog & Automatic Failover 15. Sharding Architecture: mongos Router, Config Servers & Shard Key Selection 16. Range vs Hash Sharding, Chunk Balancing & Jumbo Chunks Mitigation 17. Change Streams: Building Real-Time Event-Driven Pipelines with MongoDB 18. Production Backup Strategies: mongodump/mongorestore, Point-in-Time & Atlas CLI

Interactive Lesson Studio

# 13. Multi-Document Distributed ACID Transactions with Sessions

> MongoDB Notes by Rishabh - Topic 13

---

### 1. ACID Transactions in MongoDB (Bank Transfer Example 🏦)

Single document updates hamesha atomic hoti hain.  
Lekin jab Account A se ₹10,000 debit karke Account B me credit karna ho — **Multi-Document ACID Transactions (All-or-Nothing)** mandatory hain!

```typescript
const session = client.startSession();

try {
    session.startTransaction({
        readConcern: { level: "snapshot" },
        writeConcern: { w: "majority" }
    });

// 1. Debit Account A
    await accounts.updateOne(
        { _id: "ACC_A", balance: { $gte: 10000 } },
        { $inc: { balance: -10000 } },
        { session }
    );

// 2. Credit Account B
    await accounts.updateOne(
        { _id: "ACC_B" },
        { $inc: { balance: 10000 } },
        { session }
    );

// 3. Commit Transaction atomically!
    await session.commitTransaction();
    console.log("✅ Bank transfer completed atomically!");
} catch (error) {
    // 💥 Rollback everything if any step fails:
    await session.abortTransaction();
    console.error("❌ Transaction aborted, money safe:", error);
} finally {
    await session.endSession();
}
```

---

### 2. Distributed Transactions in Sharded Clusters (2-Phase Commit 2PC)

Sharded MongoDB cluster me jab transaction multiple independent shard replica sets ko touch karti hai:
1. **Prepare Phase:** Coordinator `mongos` saare participant shards se poochta hai: *"Kya tum commit ke liye ready ho?"*
2. **Commit Phase:** Agar saare shards ready hain, toh coordinator final commit command broadcast karta hai.

---

### 3. Master Comparison Matrix

---

### 4. Interview Ke 3 Sawal Is Topic Se

1. **`TransientTransactionError` aane par application ko kya karna chahiye?** -> Network glitch ya lock contention ke waqt transaction ko automatic retry loop me re-execute karna chahiye (`withTransaction` helper handles this).
2. **MongoDB transactions me maximum execution time limit kyu hoti hai?** -> Taaki open transactions WiredTiger cache me dirty snapshots ko indefinitely lock na rakhein aur memory leak na create karein.
3. **DDL operations (jaise `createIndex` ya `dropCollection`) transaction ke andar allow hote hain kya?** -> MongoDB 4.4+ me collections auto-create ho sakti hain, lekin index creation aur collection drops transaction ke andar strictly disallowed hain.

---
**Next Topic:** 14. Replica Sets Architecture: Primary Election, Oplog & Automatic Failover

Loading lesson content...

Python 3.12

Full IDE

Live Execution Terminal

Click "Execute Live" to run code.
                

Lesson Mastery AI Quiz

AI Doubt Solver

CERTIFICATE OF COMPLETION

Rishabh Gehlot

PHP 8+ & Laravel 11 Master Track