Assume that there is a bank which has more than 5 billion customers, 0.5 billion customers login to the online portal to do the usual transactions.
How would be the system architecture for such a bank ? How they achieve sharding on the DB (since banks uses SQL, I am interested in this specific part)?
Arpit Mohan
CTO @ Appsmith
I'm not sure how banks design their entire system. Also, 5 billion customers is too much for any bank. But that's besides the point.
An interesting tip that I got from a CTO to handle large transactional data such as this was:
For other more static data, such as Customers table, most enterprises I've seen shard the data on the value of the id column. They estimate how many users they'll see in the next 5 years and accommodate for those many horizontal shards in the DB.