🔴 - To support my channel, I’d like to offer Mentorship/On-the-Job Support/Consulting - me@antonputra.com
@alonsoalcantar78475 ай бұрын
Ive tried to understand sharding for crypto purposes but every "crypto sharding" video display vague descriptions. I stumbled upon this by accident and it was great. Amazing work 🙌
@AntonPutra5 ай бұрын
thanks!
@abdoulhamidcoulibaly23853 ай бұрын
Very helpful. I just discovered sharding not long ago in my new position. I didn't understand a thing until your video.
@AntonPutra3 ай бұрын
thank you!
@aslan1504 Жыл бұрын
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.
@tonnytrumpet7343 ай бұрын
Thanks for this comment. Could you maybe clarify ? By data loss you mean the reverse proxy or whatever way of communicating with databases wont be able to know where to search for the information right ? however the information would still be here. Although it would be extremely computationally hard there would still be way to recover it right ? You could for example recalculate hashes for all the data and redistribute those that aren't belonging to the right database based on the sharding prefix ?
@aslan15043 ай бұрын
@@tonnytrumpet734 oh yes, data will still be there, but it basically will become unusable. It's like creating yourself problems to solve.
@Xaoticex9 ай бұрын
Nice, exhaustive and short video considering it covers a lot.
@ashutoshtiwari43985 ай бұрын
No Nonsense, direct to point, covering all cases. Well-compiled video!
@AntonPutra5 ай бұрын
thank you!
@PhillyHank10 ай бұрын
Very helpful. Very confused and to the point! I hope your colleagues who do technical videos would follow your framework. 👍🏾👍🏾👍🏾
@nero4581 Жыл бұрын
Great Video, as always, Anton!
@AntonPutra Жыл бұрын
Thanks, if you think anything can be improved, please let me know!
@GabrielPozo Жыл бұрын
Great video! Always an important topic when we think about scale our systems.
@AntonPutra Жыл бұрын
Thank you!
@topoisonfungus2 ай бұрын
Thank you much appreciated 👍
@AntonPutra2 ай бұрын
thanks :)
@meron6913 Жыл бұрын
Great video Anton.
@AntonPutra Жыл бұрын
Thank you!
@xardiannon50387 ай бұрын
Superb explanation, and never strayed off topic.
@helciopandelo Жыл бұрын
Truly awesome and simple to learn!!! Thank you!!!
@AntonPutra Жыл бұрын
Thank you for the feedback!
@charlesopuoro529511 ай бұрын
Thank you so much for this clear, insightful explanation of Database Sharding.
@AntonPutra11 ай бұрын
Thank you, Charles!
@bunnybal4 ай бұрын
Really very well explained, thank you very much.
@AntonPutra4 ай бұрын
thanks!
@nicgeorge6126 Жыл бұрын
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
@AntonPutra Жыл бұрын
Thanks! There a lot of distributed databases based on postgres that can shard for you.
@gnsc22 күн бұрын
Good explanation
@AntonPutra22 күн бұрын
thanks!
@dimadiachenko1 Жыл бұрын
Awesome video! thanks for explaining it
@AntonPutra Жыл бұрын
Thanks!
@MagDag_3 ай бұрын
Классное видео, спасибо. Какая стоимость ваших услуг? Нужна консультация для Homelab.
@AntonPutra3 ай бұрын
Privet, spasibo! At this point, I can offer one-on-one sessions. I ask that you send me any questions before the session so that I can prepare some examples, and we can go through them during the meeting. I charge $100 per 1 hour session. If you are interested, pls send me an email.
@erkanakgul69548 ай бұрын
Great explaination! Thanks
@AntonPutra8 ай бұрын
thank you!
@vikasgoel75299 ай бұрын
Excellent described
@AntonPutra9 ай бұрын
Thanks!
@dhruvpatel6604 Жыл бұрын
Excellent tutorial
@AntonPutra Жыл бұрын
Thank you!
@henrik309816 күн бұрын
thanks bro
@pancazful19 күн бұрын
tutorial like south Indian suspense thriller movies , cant blink your eyes
@AntonPutra19 күн бұрын
i know, getting used to :)
@egitim106 ай бұрын
Short,nice,clear
@EpoxyArt7 ай бұрын
Hi, Anton! How can I search by the field that is not shard key? I need to go thru all the shards? And what if I need to scale it up or down (change shards number)?
@MuhammadBilalAzhar-e7s6 ай бұрын
you said sharding have unique data sets if one sharding not respond then other sharding response you but if customer search record and that record will be in sharding 1 . After that sharding 1 will not respond then what we have to show for customer
@thewaygoesup Жыл бұрын
your example confusing between database shard and table partitioning range-base sharding is about one table sharding not about database sharding.
@AntonPutra Жыл бұрын
Noted, will improve
@ProSunnySharma Жыл бұрын
Excellent! What tool do you use to do animations?
@AntonPutra Жыл бұрын
Thanks Adobe suite
@rayaalkhateeb87411 ай бұрын
thanks a lot for explaining
@AntonPutra11 ай бұрын
my pleasure!
@tejapolisettysai695011 ай бұрын
sir thanks for the video, what do you use for editing, its really good.
@AntonPutra11 ай бұрын
thanks, adobe suite
@rahuldinesh2840 Жыл бұрын
Can I do sharding in WordPress database?
@AntonPutra Жыл бұрын
WordPress uses a MySQL database under the hood. Take a look at Vitess.
@gcheese2511 ай бұрын
great video! start subscribing now
@AntonPutra11 ай бұрын
Thank you!
@andherium Жыл бұрын
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
@cariyaputta Жыл бұрын
Yes. Still, it's useful to have a knowledge of whatever jargons uppermamagements are throwing at you.
@AntonPutra Жыл бұрын
For personal projects, sure, but in the enterprise, you frequently have to deal with sharding.
@noahgsolomon Жыл бұрын
w video
@AntonPutra Жыл бұрын
thanks
@APoIIy Жыл бұрын
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.
@AntonPutra Жыл бұрын
Nowadays, once a year, I see a new distributed database based on PostgreSQL come out, lol.
@yuvrajput2 ай бұрын
Bro why are you in such hurry ?
@AntonPutra2 ай бұрын
🤷
@yoggg93211 ай бұрын
Feels like a bot is reading the script. Good content, but please act it out a bit.
@AntonPutra11 ай бұрын
thanks for the feedback
@jasper50167 ай бұрын
Hard to believe this top-notch content has very less views. Thanks a lot, Anton!!
@AntonPutra7 ай бұрын
❤️
@jackfrost89696 ай бұрын
probably coz it basically has no volumn
@ordered_saddle59 күн бұрын
and here is that one video which clarifies it simply, thank you. you made it easy like drinking milk.
@AntonPutra9 күн бұрын
thanks :)
@agun21st Жыл бұрын
Thank you sir for detail explaination of database sharding. We hope a practical handson of Database sharding will publish soon.
@shanchessmetilda55506 ай бұрын
Great Explanation....Thanks for the efforts
@AntonPutra6 ай бұрын
Thanks!
@69k_gold4 ай бұрын
Let's say I'm using a shard-nothing architecture, now let's say there's a relationship between customers table, payments table and orders table. Customers and orders tables are linked by the foreign key customers->id ~ orders->customer_id Orders table and payments table has the foreign key orders->id ~ payments->order_id Now how would you shard this database? You can't use a single shard key, because both customer_id and order_id are important that ensure all the related rows are in a single shard. So how would you solve this problem?
@ricardorqr Жыл бұрын
How do you create the animation for your videos? They are so cool!!!!! 💪🏼
@AntonPutra Жыл бұрын
Thanks! I use adobe suite.
@Jaguar16122 ай бұрын
So how to solve hotspot problem?
@LiseGarito6 күн бұрын
Thanks for the forecast! 📊 Need some advice: 🙏 I have these words 🤨. (behave today finger ski upon boy assault summer exhaust beauty stereo over). Can someone explain what this is? 😅
@AntonPutra6 күн бұрын
?
@yourname-scorpion4 ай бұрын
Great video, thank you
@AntonPutra4 ай бұрын
thanks!
@ab_azmi558411 ай бұрын
Great video. Clear & easy to understand.
@AntonPutra11 ай бұрын
Thanks Ab!
@bossgd100 Жыл бұрын
thank you for these explanations
@AntonPutra Жыл бұрын
thanks for visiting
@LinuxForLife Жыл бұрын
Very interesting! Thanks! 👍
@AntonPutra Жыл бұрын
welcome! my pleasure
@mortezamoradi-e6g8 ай бұрын
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.
@AntonPutra8 ай бұрын
If you shard manually at the application level, you need to write logic to rebalance it yourself. It's easier to use built-in mechanisms for sharding.