Solved

deploying a web application to multiple global regions

Posted on 2014-04-23
1
189 Views
Last Modified: 2014-05-06
We develop web applications for global clients, on IIS with a SQL backend.  Until now, the apps have been hosted from a single location (data center) in the US.  As we expand, we are having more global clients, and some feel that the latency experienced by clients with locations on the other side of the planet is too great. (up to 400ms latency)  The thought is to implement an infrastructure somewhere on the other hemisphere, to address the latency from clients over there.  The infrastructure is easy.  Now the hard part.  Our applications are heavily database driven - and if multiple databases are used, i.e. one in the US and one in say, India, for a global client, we'll have records from US personnel in one database server and records from EU/EMEA/ASIA PAC client personnel in another.  The applications rely on updated databases, so they will need to be synchronized somehow I think.

I know this is more of a problem for the developers, but I wanted to try and get a head start on how best to accomplish this, before leaving it in the hands of the development team. (I deal primarily with the infrastructure)

Anyone have a quick paragraph or two on how global applications are designed using multiple databases?  I know we could simply give up on real-time updates and synchronize every hour or something like that, but we rely on tracking user access, and need that to be relatively real time...  

Thanks
0
Comment
Question by:mchad65
1 Comment
 
LVL 8

Accepted Solution

by:
ProjectChampion earned 500 total points
ID: 40017666
1. Come to Iceland! : )
We're midway between the two continents and the data center fees are the cheapest, thanks to the low-cost, eco-friendly geothermal energy.

2. Take a look at articles about distributed databases.

3. As far as SQL Server is concerned you have an artillery of powerful tools and features which can be combined to suit your specific scenario. Take a look at the replications, mirroring and always-on feature in SQL Server (the latter only available since 2012 onward).
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now