Title | : | When should you shard your database? |
Duration | : | 21:20 |
Viewed | : | 77,395 |
Published | : | 28-04-2020 |
Source | : | Youtube |
Database Application level sharding is the process of splitting a table into multiple database instances in order to distribute the load. However, Sharding a database is an expensive operation (maintainability and overhead) and I suggest you do that only when you absolutely need to. That means when your single instance database can no longer serve queries with minimum latency. So I suggest you monitor that and only shard if necessary.. I rather do replication make master / backup and make requests read from replica than Sharding just because it is easier.. good question... nice idea for a video Time codes 0:00 Intro 5:00 Partition horizontally 7:45 Replication (Master/backup) Scale reads 11:00 Scale writes by region 12:30 Sharding 16:40 Sharding in YouTube ๐ญ Software Architecture Videos https://www.youtube.com/playlist?list=PLQnljOFTspQXNP6mQchJVP3S-3oKGEuw9 ๐พ Database Engineering Videos https://www.youtube.com/playlist?list=PLQnljOFTspQXjD0HOzN7P2tgzu7scWpl2 ๐ฐ Network Engineering Videos https://www.youtube.com/playlist?list=PLQnljOFTspQUBSgBXilKhRMJ1ACqr7pTr ๐ฐ Load Balancing and Proxies Videos https://www.youtube.com/playlist?list=PLQnljOFTspQVMeBmWI2AhxULWEeo7AaMC ๐ Postgres Videos https://www.youtube.com/playlist?list=PLQnljOFTspQWGrOqslniFlRcwxyY94cjj ๐ขDocker https://www.youtube.com/playlist?list=PLQnljOFTspQWsD-rakNw1C20c1JI8UR1r ๐งฎ Programming Pattern Videos https://www.youtube.com/playlist?list=PLQnljOFTspQV1emqxKbcP5esAf4zpqWpe ๐ก Web Security Videos https://www.youtube.com/playlist?list=PLQnljOFTspQU3YDMRSMvzflh_qXoz9zfv ๐ฆ HTTP Videos https://www.youtube.com/playlist?list=PLQnljOFTspQU6zO0drAYHFtkkyfNJw1IO ๐ Python Videos https://www.youtube.com/playlist?list=PLQnljOFTspQU_M83ARz8mDdr4LThzkBKX ๐ Javascript Videos https://www.youtube.com/playlist?list=PLQnljOFTspQWab0g3W6ZaDM6_Buh20EWM ๐พDiscord Server https://discord.gg/CsFbFce Support me on PayPal https://bit.ly/33ENps4 Become a Patreon https://www.patreon.com/join/hnasr? Stay Awesome, Hussein
![]() |
Database Sharding and Partitioning 23:53 - 77,097 |
![]() |
What is Database Sharding? 26:56 - 153,908 |
![]() |
Event Sourcing and CQRS Explained | When shoul... 12:36 - 4,154 |
![]() |
Types of Databases: Relational vs. Columnar vs.... 18:23 - 38,678 |
![]() |
They Enabled Postgres Partitioning and their Ba... 31:52 - 40,007 |
![]() |
What is a Message Queue and When should you use... 13:05 - 144,565 |
![]() |
Avoid premature Database Sharding 20:29 - 15,936 |
![]() |
when indexes are useless | The Backend Engineer... 26:25 - 23,377 |