Inside the Database Engine: MySQL, PostgreSQL & MongoDB – Architecture

🧠 You use databases every day. But do you really know how they think, store, index, replicate, recover?

This meetup is your full-access pass into the internal organs of the world’s 3 most powerful databases. 💾

### ⚙️ Session 1: MySQL Internals Unlocked

> Learn how MySQL evolved from a simple relational engine to a high-performance transactional beast.

• Storage Engines: InnoDB vs MyISAM
• How B+ Trees power indexes
• Redo Logs, Undo Logs & Doublewrite Buffer
• Query Optimizer Tricks – EXPLAIN plan analysis
• ACID + MVCC (multi-version concurrency control)
• Replication: Binlogs, GTIDs, Semi-sync
• Partitioning, Sharding Strategies
• Common MySQL Bottlenecks (with Fixes!)

### 🧠 Session 2: PostgreSQL – The Architect’s Database

> Postgres is not just SQL, it’s object-relational power with engineering-grade control.

• Process-based architecture: Background workers, WAL writer
• WAL Logs (Write-Ahead Logging) and crash recovery
• Query Planning: Cost-based optimizer
• PostGIS, JSONB & Full-Text Search internals
• Extensions & Hooks (pg_partman, TimescaleDB, Citus)
• MVCC & Vacuuming Mechanism
• Horizontal scaling with logical replication

🛠 Live Demo: Show query planning cost comparison + visualize WAL logs

### 🧬 Session 3: MongoDB – Document Magic Internals

> From flexible schemas to replica sets, MongoDB hides powerful structures beneath its JSON-style simplicity.

• BSON Storage Format vs JSON
• Storage Engine: WiredTiger internals
• Journaling and Checkpointing
• Replica Set: Oplog, Elections, Failover
• Sharding Architecture with Query Router (mongos)
• Indexing: Compound, Geospatial, Text
• Aggregation Pipeline Optimizations

🛠 Live Demo: Trigger a failover in a local replica set + aggregation perf tip

### 💎 Bonus Sessions:

• ✅ Build Your Own Storage Engine (in Python/Go)
• 🔐 Security Internals: Roles, Row-level Security, Field-Level Encryption
• 📊 Performance Engineering: How to benchmark DBs like a pro
• 🔁 Database Observability: Query logs, audit trails, slow query analysis

### 🎁 What Meetup Attendees Get:

• 🧾 PDF: Coderrange DB Internals Cheatsheet
• 🧪 CLI Labs to simulate replication, crash recovery, and WAL logging
• 💡 Decision Guide: “Which DB for which use case?”
• GitHub link with mini DB internals demo repo
• Access to “Build Your Own Query Optimizer” workshop invite

### 🎯 Ideal for:

• Backend & Full-stack Devs
• Data Engineers & Architects
• DBAs and Curious Founders
• Anyone scaling microservices & data platforms

“Every CRUD operation has a story. Let’s decode it.”
Learn the real internals. Build better systems.

Join Zoom Meeting

[https://us02web.zoom.us/j/87974476249?pwd=FoaaWxiEsb6tlGdrBbBX4MYbFdyom9.1](https://www.google.com/url?q=https://us02web.zoom.us/j/87974476249?pwd%3DFoaaWxiEsb6tlGdrBbBX4MYbFdyom9.1&sa=D&source=calendar&usd=2&usg=AOvVaw3NKJF4SLoX1BMfa58IdCuA)
Meeting ID: 879 7447 6249
Passcode: 755661