Ultra-Scale Metadata Storage for Video Streaming
Design a highly-available metadata storage system for a global video streaming platform with 100M+ DAUs. The system must handle massive write loads for watch progress tracking (1M+ events/sec) and provide low-latency access to the content catalog. Specifically, address how you would scale a relational database architecture (Postgres-based) to meet these requirements while handling connection management, data partitioning, and write-heavy bottlenecks. Discuss the trade-offs between consistency and performance for playback features.
PostgreSQLRedisKafkaPGBouncerS3CDNCDCJSONB
00