App is hosted in North America, Europe and Asia. All regions have the same instance of the app, but connected to different MongoDB databases hosted in Atlas in the same region as the app.
Each region’s app is connected to different database because it would take long for database requests if the app is not hosted in the same region as the database itself.
The biggest issue now is if the user is registered in North America’s instance, his user record will be stored in North America’s database. So if the same user tries to login later in the Europe or Asia instance, he would not succeed since these databases do not have that user record.
What is the best practice to have one centralized database that would be fast for all regions globally. Can that be done with Atlas? Is it possible to host replicas set of one cluster in different regions?
All suggestions and recommendations are welcomed.