none
Private Cloud - VMM RRS feed

  • Question

  • Hi , we have a private cloud between 3 sites.  we looking at building SQL server highly available & DR etc.

    initially you would think of two node guest cluster on primary site , remote sites  High Availability Groups. 

    If we are using private cloud , am I correct in saying we don't need to have HA groups on remote sites.  All we need is a two node cluster setup as a service.  If setup correctly , in the event of disaster

    the cloud platform , can deploy a third node , which will be passive (active node crashed , passive node became active)

    in the event we loose a building block (primary site)  , the cloud platform can bring up the entire service on a secondary site

    there is no need for HA Groups ,  HA FCI  as a service only would be sufficient

    thanks

    Tuesday, March 18, 2014 11:37 AM

Answers

  • Hi Mr Mohamed Ismail,

    The private cloud offers high availability for mission-critical SQL Server workloads by offering Live Migration and guest failover clustering capabilities. For example, you can use Live Migration to move running SQL Server VMs from one Hyper-V host to another without service disruption or downtime. You can use guest failover clustering if additional protection is required from unplanned downtime. A guest failover cluster is simply a SQL Server failover cluster. However, each node affiliated with the SQL Server failover cluster is virtualized within the private cloud.

    With the release of SQL Server 2012, you can leverage AlwaysOn Availability Groups to provide both high availability and disaster recovery for your databases running on SQL Server 2012 instances within the Microsoft Private Cloud. You can also leverage AlwaysOn Failover Clustering to create a multi-subnet guest cluster between two data centers. For more information about private cloud, you can review the following article.

    http://sqlmag.com/sql-server/sql-server-microsoft-private-cloud

    There is an blog of step-by-step building a Windows Server 2012 Failover Cluster Study Lab in the Cloud with Windows Azure, you can review it.
    http://blogs.technet.com/b/keithmayer/archive/2013/02/04/step-by-step-building-a-windows-server-2012-failover-cluster-study-lab-in-the-cloud-with-windows-azure.aspx#.UykzeXmKBes

    Hope it can help.

    Regards,
    Sofiya Li


    Sofiya Li
    TechNet Community Support

    Wednesday, March 19, 2014 6:24 AM
    Moderator