Similar Q as previous chapters. VideoID sharding would still need Consistent Hashing to avoid future redistribution.

If we go with static modulus, 100 db servers meaning, videoid % 100, means when we need more we need to reshuffle the data.

Also, why not use nosql in this case? Since they can easily scale horizontally unlike mysql which are good with vertical scaling.