Building on AWS | Read Replica Vs Multi AZ | Handle reporting query without crashing prod

00:00 - The Scenario: Airbnb's Metadata & Reporting Architecture
02:50 - The Problem: How Long-Running SQL Joins Kill Performance
06:20 - Root Cause Analysis: CPU, IO, and Connection Exhaustion
09:10 - Deep Dive: MVCC, Snapshots, and Memory Usage
14:35 - The Solution: Splitting Writes (Primary) and Reads (Replica)
15:50 - Critical Concept: Read Replica is NOT High Availability (Multi-AZ)
18:50 - Uber Case Study: Real-time Bookings vs. Analytical Queries
20:00 - The Trade-off: Handling Replication Lag & Eventual Consistency
22:20 - How Replication Works: WAL Streaming & Replay
25:35 - Architecture Pattern: Multi-AZ vs. Read Replicas Explained
29:30 - AWS Implementation: RDS & Aurora Replicas
30:08 - Conclusion & Key Takeaways

Видео Building on AWS | Read Replica Vs Multi AZ | Handle reporting query without crashing prod канала Code And Joy