9. Modern Data Architecture
HTAP, distributed SQL consensus, sharding topologies, and polyglot storage
Covers PostgreSQL vs. MySQL architectural decision matrices, MongoDB sharding and chunk split triage, Distributed SQL consensus algorithms (Raft/Paxos), and DuckDB embedded HTAP analytical caching.
Module Syllabus & Lessons2 Lessons
Click published lessons to start learning immediately. Upcoming lessons detail planned objectives below.
The Modern DBA Academy curriculum maps directly to dbaguide's battle-tested deep-dive articles, incident runbooks, diagnostic scripts, and architecture blueprints. Published items connect directly to their verified engineering resources.
PostgreSQL 17 vs. MySQL 8.4 LTS Architectural Matrix
Process-per-connection vs. threaded models, vacuum vs. undo purge, and workload suitability.
- •Compare PostgreSQL process-per-connection scaling with MySQL multi-threaded connection handling
- •Architectural decision criteria: complex queries and JSON in Postgres vs. high-concurrency simple OLTP in MySQL
Distributed SQL Consensus & Architecture (Raft/Paxos)
Distributed SQL architectures: Multi-Raft consensus, atomic cross-node transactions, and TrueTime clocks.
- •Understand the interplay between Two-Phase Commit (2PC) and Raft consensus in distributed transactions
- •Analyze partition tolerance and consistency trade-offs under simulated split-brain conditions
Get notified about new lessons and labs in 9. Modern Data Architecture.
Receive instant updates whenever new engineering modules, emergency incident runbooks, diagnostic scripts, and one-command Docker drills are published.