What is Database Sharding, Logical and Physical Shards, Dynamic vs Algorithmic Sharding | 2021

This is the twenty-first video in the series of System Design Primer Course. We talk about one more important component of System Design: Sharding. We want software engineers and aspiring software engineers to develop basics and get ready for the world of interviews as well as excelling as a Software Engineer. We talk about the following: Horizontal vs Vertical DB Partioning Logical vs Physical Shards Algorithmic vs Physical Sharding Pros and Cons of Sharding ------------------------------------------------------------------ Recommendations ------------------------------------------------------------------ Our full courses on youtube: ✒ System Design Primer Course: https://youtube.com/playlist?list=PLTCrU9sGyburBw9wNOHebv9SjlE4Elv5a ✒ REST APIs made easy:https://youtube.com/playlist?list=PLTCrU9sGybupzS5-3iYTsYUI1emBDKdHu Some paid courses that we recommend: ✒Educative.io: https://bit.ly/3qnW5ku ✒Interviewready.io: https://get.interviewready.io/ (Use coupon code SUDOCODE for extra discount) ------------------------------------------------------------------ About Us ------------------------------------------------------------------ Created and Instructed by: Yogita Sharma ✒ LinkedIn - https://www.linkedin.com/in/yogita-sharma-83400b55/ ✒ Instagram - https://www.instagram.com/sudo.code1 ✒ Facebook - https://www.facebook.com/sudo.code ✒ Medium - https://medium.com/@yogita088 Post-production(editing, thumbnail etc) managed by: CiKi ✒ Website: www.ciki.co.in ✒ LinkedIn: https://www.linkedin.com/company/74735937 Colors and design by: Naini Todi ✒ LinkedIn - https://www.linkedin.com/in/nainitodi/ Both Arpit and Yogita are software engineers and want to help other software engineers become better by providing high quality and well researched content by adding their creativity and teaching twist. ------------------------------------------------------------------ Join Us ------------------------------------------------------------------ Hangout with sudoCode: ✒Discord Server: https://discord.gg/rwD2PkeAxw For business: ✒Email: [email protected] ------------------------------------------------------------------------------------------------------------------------------------ Timestamps: 0:00 - Intro 0:59 - What is Sharding ? 2:15 - Horizontal vs Vertical shards 5:46 - Logical Sharding vs Physical Sharding 8:58 - Advantages of Sharding 11:07 - Algorithmic and Dynamic Sharding 13:33 - Disadvantages of Sharding 16:06 - Some more important details about Sharding 16:40 - Outro