SQL Server Performance

How to accomplish? multiple locations

Discussion in 'SQL Server 2008 Clustering' started by Ron Sneed, Jun 12, 2011.

  1. Ron Sneed New Member

    Background:
    We have a very popular social website that is spreading worldwide.
    People accessing website in northamerica etc.. no problems, UK, France, Korea etc.. MAJOR delays
    We are putting new servers web and DB, in UK datacenter
    We will setup DNS server to send you to the "closest location"

    Question:
    How and by what method can this work from a SQL server standpoint?
    The web servers in the UK would obviously update the SQL server in the UK and likewise for the US based setup.
    How can the 2 databases work with each other in this situation?
  2. satya Moderator

    Ron
    WElcome to the forums.
    I believe I see this as a little-project than proposing an open answer.
    SQL Server has many features that can get you desired levels of availability and scalability provided the editions and features that you will be selecting.

    If your application need 24/7 data availability then it is something you can look at Database Mirroring which is a cheaper solution to clustering itself. Happy to discuss the requirement offline...

Share This Page