Globally partitioned database?

Soldato
Joined
18 Oct 2002
Posts
7,139
Location
Ironing
Bit of a strange one this.

Imagine you sold an online service to various companies around the world. It's a simple web-based service and you store data on behalf of the customer. You have your web application, and you have your database schema.

Now, some of your customers have strict data requirements which do not allow their data to leave their country. So a company working in (for example) Brazil needs to have assurance that their data will reside in a datacenter in Brazil. A company in Australia might require their data is in Australia. A company in France might not care, so it goes into where the application is currently hosted (UK).

I don't think the customers have a requirement that the application itself is hosted in their own country, just the data at rest. In theory we could have one web server in one place talking to a bunch of different databases around the world.

Finding the hosting across different countries isn't a problem. What is a bigger problem is seamlessly managing several globally distributed versions of the application and the database schema. Is it simplest just to run these separate instances entirely separately (with no knowledge of each other), or is there a better way?
 
Back
Top Bottom