What is Database Sharding?

Great explaination! Thanks

thanks, but i have a question if i use range-based sharding and conside 4 shard what happen if i want to convert to 40 shard? what happen for previous data, and new data [ first i have 3 shard 1(a-h) 2(i-p) 3(q,z)) now need to make it 40.

Nice, exhaustive and short video considering it covers a lot.

Excellent described

Very helpful. Very confused and to the point! I hope your colleagues who do technical videos would follow your framework. 👍🏾👍🏾👍🏾

Great video. Clear & easy to understand.

thanks a lot for explaining

Thank you so much for this clear, insightful explanation of Database Sharding.

Feels like a bot is reading the script. Good content, but please act it out a bit.

great video! start subscribing now

sir thanks for the video, what do you use for editing, its really good.

Excellent! What tool do you use to do animations?

w video

Can I do sharding in WordPress database?

So, sharding is a pain in the ass and requires a lot of configuration, analytics and also business logic to manage shards in an respectable way.
This is also why NoSQL Databases come in handy as they can scale better horizontaly without this extensive configuration activities you have with traditional SQL databases.
But to be said SQL Databases will probably cover 90% of all usecases anyway without you getting into sharding.

Excellent tutorial

As for the hashing, you probably will take hash only of a subset of columns of a record, most probably - only primary key, because changing any field of any record will result the hash to change also, which leads to data losses.

Thank you for the concise explanation. I wanted to understand how to manually implement sharding?

your example confusing between database shard and table partitioning
range-base sharding is about one table sharding not about database sharding.

Truly awesome and simple to learn!!! Thank you!!!

Great video! Always an important topic when we think about scale our systems.

Great video Anton.

Awesome video! thanks for explaining it

How do you create the animation for your videos? They are so cool!!!!! 💪🏼

Very interesting! Thanks! 👍

Thank you sir for detail explaination of database sharding. We hope a practical handson of Database sharding will publish soon.

thank you for these explanations

I think 99.9% use case are served fine by a monolith database server. Heck even stack overflow is fully powered on a single server

Great Video, as always, Anton!

Fortunately I’ve been able to get by with two read databases and a write by using table partitioning up until this point. Hopefully I don’t have to tackle sharding any time soon! Great video and thanks for sharing