AlwaysOn Availability Groups - Getting Started with SQL Server 2014 Administration - page 70

Creating an AlwaysOn Availability Group in
Microsoft Azure
In this section, we will look at creating an Availability Group that resides entirely
in Microsoft Azure. In order to configure this on Microsoft Azure, you need
the following:
• A virtual network setup in Azure
• A storage account setup
• A Microsoft Azure domain controller
• WSFC
• One or more Microsoft Azure Virtual Machines with SQL Server 2014
installed and configured for AlwaysOn Availability Group
Build the Availability Group just as you have read in the previous tutorial. As you
can see, in this case, it is the Infrastructure as a Service ( IaaS ) you have configured
everything else. The following tutorial provided by Microsoft takes you through
creating the necessary Microsoft Azure infrastructure.
Creating a Hybrid Availability Group
It is possible to combine on-premise and Microsoft Azure-based virtual machines
to create a hybrid Availability Group. To do this, you need:
• A virtual network that contains multiple subnets, including a frontend and a
backend subnet
• A domain controller and the SQL Server 2014 machines that you need to run
behind a VPN device in your on-premise network
• A site-to-site VPN connection between the Microsoft Azure VPN device and
your on-premise VPN device
• A SQL Server VM deployed to the backend subnet in Microsoft Azure and
joined to your on-premise AD domain
• A WSFC multisite cluster with the Node Majority quorum model
• An Availability Group with two synchronous commit replicas on on-premise
and one asynchronous-commit replica on Windows Azure