High Availability design across two separate physical location ?

[AlbertWT]

Hi All,

Can anyone suggest if this is possible to achieve Active-Active SQL Server 2008 database implementation using VMware (HA or FT) or any other Windows Clustering or SQL Server technologies for sites that spans across two different physical location and subnet ?

if so please share how do you approach this.

Thanks.

[AndreTheGiant]

VMware FT is a active-standby solution... so no.

VMware HA is a VM restart solution... so no.

The way could be a guest clustering solution, but you have a storage shared across the two site?

Otherwise you must try to use DB mirroring or similar specific feature of SQL Server.

Andre

[AlbertWT]

Yes, I wonder if that is possible with VMware hypervisor HA/clustering combined with SQL Server clustering.

I do have EMC CX4 SAN with SnapView for replication over dark fibre between two sites.

[AndreTheGiant]

As I know is not possible.

You must see in SQL Server features (mirroring, subscriptions or log shipping), and hadle the access of the data at application level.

Andre

[AlbertWT]

That’s why I wrote the question in this thread if it is OK for me to combine the SQL Server clustering on top of VMware HA or even FT.

[AndreTheGiant]

For VMware HA  no problem.

About VMware FT probably you can't (due to the 1 vCPU limit) and also make not sense if you have a guest cluster solution that protect the service.

Andre