What would you be running on your webservers/mysql servers?
Is it just one site (your own)? Any solution must take into
account what you're running, and how any updates (sql)
are done etc. The solution would follow once the site's
technical details are known.
Ideally we want one of the sites close to us (Los Angeles), so softlayer wouldn't really be a fit. Thanks for the help though, it's helping me on my Google searches!
The big question here is what platform do you use as each SQL vendor has specifics for replication / clustering / failover. HTTP content and other static objects are rather trivial to replicate and fail-over.
It can be done with multiple hosts, but it is best when you have a company two geographically separated datacenters with redundant paths and routing from each as well as interconnecting fiber between the two. This keeps latency at its lowest and allows for private vlans between servers in the two datacenters. This is a very customized solutions that takes coordination between the network engineers and system administrators to setup, but it an excellent solution for high redundancy, load balancing, and failover.
- Donovan K Want to monitor and manage your customers Windows systems by Client software, web portal, or mobile phone?
Automated scripts, patching, and remote access too? Ask me how!
This would be for two servers (VM guests), one is a plain ISS webserver and the other runs MSSQL 2005.
The servers will be hosted at one colo, with the DR servers at another colo.
Ideally, we need real-time (or as close to real-time) replication between the two servers. I've come across some SQL solutions (xkoto being one of them) but I have not yet received any quotes. If they turn out to be too much for us, then we may have to settle for 5-15 minute snapshots and a more manual solution.
Since you're using Windows exclusively, you can do geo-dispersed failover clustering. If you're on Windows Server 2008, you won't need to worry about each end being in the same subnet, thus can use two different datacenters.