Перейти к содержимому

Why SQL Fails at Scale | NoSQL Databases Explained | System Design EP 05

love & code

0:00 / 0:00

Why SQL Fails at Scale | NoSQL Databases Explained | System Design EP 05

48 просмотров · 11 дней назад
love & code
23 подписчика
48 просмотров · 11 дней назад
🔗 System Design Series Repository: https://github.com/balajz/system-desi... Why did Netflix completely throw away their SQL database in 2008? Discover the exact NoSQL architecture they used to fix a massive 3-day outage and scale their backend to millions of users. Traditional SQL databases are powerful, but their strict schemas and rigid consistency can create a single point of failure under immense global load. In System Design EP 05, we break down why relying solely on relational databases can sabotage your backend when trying to scale horizontally. This video reveals the inner workings of distributed NoSQL databases like MongoDB and DynamoDB. You will see exactly how data is distributed across multiple servers using hash functions and key spaces, ensuring your application never goes offline even if a server fails. However, NoSQL is not perfect. We expose the hidden trade-offs, such as eventual consistency and poor join performance, so you know exactly when to choose NoSQL for high-scale applications and when to stick with SQL for strict banking systems. What you'll learn: Why Netflix migrated away from traditional SQL databases How horizontal scaling works in distributed systems The mechanics of key spaces and hash functions for data distribution How fault tolerance and backups operate in NoSQL Trade-offs between Eventual Consistency vs Strict Consistency When to choose NoSQL over SQL for real-world backend projects 00:00 - The 2008 Netflix Database Failure 00:38 - Problems with Traditional SQL Databases 01:50 - What is NoSQL & How it works 03:21 - Distributed Systems & Horizontal Scaling 04:00 - Understanding Key Spaces & Hash Functions 06:12 - Fault Tolerance & Backups in NoSQL 06:47 - Cons of NoSQL (Data Inconsistency) 08:09 - When to use NoSQL vs SQL Welcome! This channel is dedicated to helping students and software engineers master complex computer science concepts, system design, and backend development in Tamil. 🔗 Connect with me: Subscribe:    / @loveandcode   ► GitHub: https://github.com/balajz ► LinkedIn:   / balajiz   ► LeetCode: https://leetcode.com/u/Balajix/ ► Website: https://balajz.vercel.app/