My organization has two North American offices that are close enough to share a single web app server and database with minimal latency. However, we’re opening an office in India and that amount of latency is not acceptable.
It has to be hosted on-prem for security reasons, so no cloud hosting.
What’s a common implementation of this scenario to ensure data stays in sync? Do you use multiple DBs with one being the master? Some sort of constant syncing? I’m a bit new to this problem. Any pointers would be amazing. MongoDB and PostgreSQL