Let say I have 2 data centers in 2 different cities. Datacenter A to serve city A, and datacenter B to serve city B. How do I achieve the following scenarios:
- Redirect users in each city to respective datacenter. City A to Datacenter A, and likewise with city B.
- Any changes to the data in any of the Datacenter should be reflected to the other datacenter.
- In an event of downtime in one of the datacenter, traffic to the problematic dataserver should be redirected to the other datacenter.
The above is for a website with database, using Microsoft technologies (server and database).