Got a major issue that I need some help with. Here is the situation.
The client has multiple web sites hosted on multiple web servers (virtual machines) running on multiple virtual hosts that connect to a backend domain that have multiple SQL clusters (active / passive) for the multiple websites. (to clarify, the web sites each connect to a separate database cluster, they have 3 clusters)
What we would like to do is setup the SQL database servers to be able to serve the data for multiple website servers in multiple locations and having the SQL servers be in high availability. The data needs to be the same across the board.
They want their DRP site to now be a live extension of the production environment essentially making two live environments with web servers on virtual hosts in both locations and SQL clusters in both locations and the data cannot be different as the web users will be load balanced across both.
My question is what is the best way to setup the SQL servers across these two location?
Thanks in advance.