Tutorial: Horizontal sharding with PlanetScale

[@ahmad-murery]

Nice. I wonder what exercise made Lily feel great?

[@HollyGuevaraPS]

Just checked the exercises table. Looks like she was doing conventional deadlifts! Lily is my dog so I guess that's pretty impressive :D

[@ahmad-murery]

@@HollyGuevaraPS great, we'll have another Anatoly soon (if you know what I'm referring to 😁)

[@HollyGuevaraPS]

@@ahmad-murery hahah she's got a sleeper build for sure!

[@ahmad-murery]

@@HollyGuevaraPS 😎

[@HollyGuevaraPS]

If you're confused about what happens to the exercises table that I mentioned we'd want to move to the sharded keyspace, it's because I only address it in the "Avoiding cross-shard queries" video (my bad!). Because it's hard/impossible to find a Vindex that guarantees all rows for a users exercises and exercise logs are on the same shard, we're actually going to utilize Vitess reference tables for that one. It allows you to make a copy of the table on every shard. This is a great option for smaller relatively static tables, such as exercises.