What is the best way to organize databases?

Question

Database

The task in general is as follows: there will be several projects that will be located in different countries. Therefore, each country will have its own server with a project. There will be a lot of traffic and, accordingly, inserts approximately (1-2 tons / min) But it is necessary that the base be unified. Actually the question is: how best to organize the storage and transmission of data, with this option? Example countries: Singapore, India and Germany. The database has not yet been selected, but presumably mysql or postgrese. Does anyone have any interesting options?

Answer 1

Why a single base? Everything will slow down due to ping between countries. Make several local databases and use Foreign data wrappers to exchange data between them.

Answer 2

If done on PostgreSQL, then partitioning by region with replication. But it's better to use something like Google Cloud Datastore.