Globally separated cluster

I am trying to plan a SQL Server 2005 cluster across multiple data
centers around the world. Basically the database backs a load balanced
web application. Each site has its own set of web servers and its own
database servers but the databases must be in sync around the world so
minimal downtime can be achieved in case one site fails (requests can
easily be redirected to the next closest site). In addition, each site
needs to have redundancy (most likely in the form of a Windows 2003
cluster). I'm guessing this is going to require some form of 3rd party
(non-Microsoft) solution but I just wanted to see if anyone else has
experience in this type of situation.

I was originally thinking mirroring the cluster but I can only do that
one time.

Thanks for any info

.

Relevant Pages

  • Re: I have question regarding active/active clustering
    ... With log shipping or database mirroring you have two complete copies of the ... With a cluster, two different servers are ... Clustering is usually done with both servers in the ... there is a period where the SQL instance which was ...
    (microsoft.public.sqlserver.clustering)
  • ActiveActive Shared Database.
    ... Is it possible in SQLServer to setup an Active/Active cluster between two servers and access the same database? ...
    (microsoft.public.sqlserver.clustering)
  • Re: Old Possums book of practical hosts.
    ... Would this cluster be running software from the large database ... Please note that I didn't name those servers (for some weird ...
    (alt.sysadmin.recovery)
  • Re: ActiveActive Shared Database.
    ... Not possible with Microsoft Cluster Server, which follows a shared-nothing ... federate the database horizontally and share my data across two ... > servers different databases. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Windows 2003 Network Load Balancing Problem
    ... Sadly my servers websites were configured with specific IPs and host ... I find it very strange why the NLB driver can receive on a virtual IP ... he set his IIS website to use ALL UNASSIGNED addresses rather than ... specifically pointing it at the single virtual cluster address. ...
    (microsoft.public.windows.server.clustering)