36ae9212a20addee842b77e88e25ffe57799d100
By:
SysLiz

How to architect the database for the mulitple countries?

December 5, 2015 1.5k views
MySQL Java Ubuntu

I will be launch my mobile app in multiple countries. But i need how to create database to multiple regions.

My doubt is,

  • Can i use single database or
  • Multiple database and one master database

Please give correct way???

Note:

Maximum One country : 5 lakhs users

1 Answer

As far as load on your server this will really depend since how many users/how much traffic a server can handle is very dependent on the software you are running and the activity the users are generating.

Building an app to work for multiple countries is a challenge and there are several ways to meet it.

Supporting multiple languages is usually used by creating a language file (or db table) where resources are mapped to an ID and language + ID can be used to return the appropriate string.

Ensuring low latency for users around the world can be accomplished either by hosting services around the world or by using a CDN or service like CloudFlare which proxies your app throughout the world.

Can you run an app for multiple countries from a single database, absolutely. As you grow, most db servers have methods for scaling across multiple servers allowing you to serve more users from a single database.

Have another answer? Share your knowledge.