One thing that I've never seen addressed fully in any video relating to sharding is the issue of how best to manage relationships. You can't do joins across shards, so all of that gluing together has to be done in memory. That's fine. But say you have a members table like in your example, but they can have many "orders". The number of orders will likely exceed that of the members table so they'll need to be sharded as well. So the question becomes: do they need to exist on their own sharded instance, how do you choose their sharding key? I'm sure there are questions relating to this that I'm not thinking of, but that's the gist of it.
One thing that I've never seen addressed fully in any video relating to sharding is the issue of how best to manage relationships. You can't do joins across shards, so all of that gluing together has to be done in memory. That's fine. But say you have a members table like in your example, but they can have many "orders". The number of orders will likely exceed that of the members table so they'll need to be sharded as well. So the question becomes: do they need to exist on their own sharded instance, how do you choose their sharding key? I'm sure there are questions relating to this that I'm not thinking of, but that's the gist of it.
Ooh great question we can definitely cover that! Exactly the type of in the weeds topics I'm looking for.
@@HollyGuevaraPS Asking questions is my only talent. Thanks for the video.
Aaron sure looks different these days
💃
At some point the d in sharding started to sound like t and I was losing my mind haha
🤣😭 never let your shard d's become t's
Excellent video! Thanks a lot!
Thank you!
Could you share what software you did use as blackboard?
Yeah I actually just make everything in Figma and then use the presenter mode when I record!