Range based sharding | Advantages and disadvantages | Hotspots | Use Cases

This is the twenty-third video in the series of System Design Primer Course. We talk about one more important component of System Design: Range based 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.

Previous videos to catch up on:
Introduction to System Design: https://youtu.be/FSR1s2b-l_I
Components of System Design: https://youtu.be/aSvOThsVe5w
Proxies: https://youtu.be/Nu-4Q3OoR4E
Client Server Architecture: https://youtu.be/Dg1U-jwVUrg
Data and data flow: https://youtu.be/YBRGp_CNzXw
Databases: https://youtu.be/O_c7lzNbcKo
Applications: https://youtu.be/iuR7rzNvbxs
Application Programming Interface: https://youtu.be/dpcILJ8BTzU
Caching: https://youtu.be/Ez1GK2imrsY
REST APIs: https://youtu.be/nUuAWn0AAiY
Message Queues: https://youtu.be/J6CBdSCB_fY
Pub Sub Part 1: https://youtu.be/EgJ7xts82Mg
Pub Sub Part 2: https://youtu.be/-vd_Ay0pvFY
Performance Metrics Part 1: https://youtu.be/HrfgslRY7Ak
Performance Metrics Part 2: https://youtu.be/R72h2D3Y76g
Fault vs failure: https://youtu.be/7vIzGmxdUvI
Scaling: https://youtu.be/G1Z7w9_vspY
DB Replication: https://youtu.be/RIcNswROzCc
CAP Theorem: https://youtu.be/pSoKUfLTe8Y

Upcoming videos in this course are as follows:
Types of Sharding
Database Indexing
..and many more.

More links:
https://www.citusdata.com/blog/2018/01/10/sharding-in-plain-english/
https://blog.yugabyte.com/four-data-sharding-strategies-we-analyzed-in-building-a-distributed-sql-database/

You can take up the full course on System Design here -
https://www.youtube.com/playlist?list=PLTCrU9sGyburBw9wNOHebv9SjlE4Elv5a


Hangout with sudoCode team:
https://join.slack.com/t/sudocode-workspace/shared_invite/zt-kgqeb4ci-vD6pRkf_KqHC4J8x0fqBPA

Follow us on linkedIn:
https://www.linkedin.com/company/sudo-code

This course on System Design is developed and curated by Yogita Sharma. You can follow her here:
LinkedIn - https://www.linkedin.com/in/yogita-sharma-83400b55/
Medium - https://medium.com/@yogita088

And it is edited by Arpit Sharma. You can find him here.
Editor: https://www.linkedin.com/in/arpit-sharma-83675296/
Channel art: 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.

For business requirements, do feel free to reach out us via:
Call: (+91)-9102175557
Email: sudocode.yogita@gmail.com

Timestamps:
0:00 - Intro
0:35 - What is range based sharding ?
3:28 - Advantages and Hotspots
5:05 - Use cases: Range based sharding
6:03 - Outro