dataiotech Labs
dbaguide/academy/modern-data-architecture
MDBA-MDARModül #9Advanced → Expert

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.

Publish Progress50%
1
Published
1
Planned
Engineered Competencies Mastered in this Module:
✓PostgreSQL 17 vs. MySQL 8.4 LTS enterprise architectural decision matrix
✓MongoDB sharded cluster chunk split failures and balancing bottlenecks
✓Distributed SQL Raft consensus, Multi-Paxos, and TrueTime global clocks
✓DuckDB embedded micro-analytics over transactional OLTP datasets (HTAP)
Share this engineering module on LinkedIn and X:

Module Syllabus & Lessons2 Lessons

Click published lessons to start learning immediately. Upcoming lessons detail planned objectives below.

MDBA
Educational & Engineering Resource Mapping

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.

MDBA-MDAR-001ReferenceAdvancedCore ConceptPublished

PostgreSQL 17 vs. MySQL 8.4 LTS Architectural Matrix

Process-per-connection vs. threaded models, vacuum vs. undo purge, and workload suitability.

Key Objectives:
  • •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
Prerequisite:MDBA-FUND-001
Next in Syllabus:MDBA-MDAR-002: Distributed SQL Consensus & Architecture (Raft/Paxos)
MDBA-MDAR-002LessonExpertDeep DiveQ3 2027 Planned

Distributed SQL Consensus & Architecture (Raft/Paxos)

Distributed SQL architectures: Multi-Raft consensus, atomic cross-node transactions, and TrueTime clocks.

Key Objectives:
  • •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
Prerequisite:MDBA-FUND-001
50 min
Syllabus Preview
CURRICULUM UPDATES

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.