News for hackers. Stuff that matters.

A comment on MangaDex infrastructure overview. Parent comment

Re:MangaDex infrastructure overview by emi2k01 on Wednesday September 08, 2021 @02:31AM (#28453779)
> 12 web servers with separate MySQL instances local to each sharded on primary key IDs.

I don't understand this part. Hopefully you can clarify this to me.

If you're sharding by primary key, doesn't that mean that there's a high chance that the shard in your local DB instance won't have the data the web server is requesting?

I'm not familiar with DB management.

[ Parent | on HN ]
Re:MangaDex infrastructure overview by radicalbyte on Friday September 10, 2021 @04:15PM (#28486393)
Imagine you have a system which services 50 states. In the vast majority of cases, states only look at or mutate information on their own state.

In that case, you can easily split the data between shards based on ranges of an integer key. It's very easy to code, test, deploy and understand such a design.

[ Parent | on HN ]