Many businesses rely on SQL Server 2008 R2 failover clusters to manage their data. However, support for SQL Server 2008 R2 and for Windows Server 2008 R2 has ended. Regular security updates are no longer available.
Customers who would like to migrate to Azure often can't change their infrastructure. The Azure shared disks feature makes migration possible in this situation. With this feature and a Windows Server 2008 R2 failover cluster, users can replicate their on-premises deployment in Azure. There's no need for third-party software to manage shared storage.
With this solution, users can:
Keep their current infrastructure.
Rehost workloads in Azure with no application code changes.
This architecture benefits organizations that rely on SQL Server 2008 R2 failover clusters to provide fault-tolerant data management. Examples include businesses in reservations, e-commerce, and logistics.
As part of a virtual network, an Azure Load Balancer redirects clients by associating a routable, private IP address with the cluster.
Two Azure virtual machines (VMs) run SQL Server 2008 R2 on Windows Server 2008 R2.
An availability set that includes the VMs guarantees the solution's redundancy and availability.
Azure Load Balancers balance traffic inside virtual networks. This architecture uses an internal load balancer. This type uses a private IP address and distributes inbound traffic to back-end pool instances. The load balancer directs traffic according to configured load-balancing rules and health probes. The back-end pool instances can be Azure VMs.
Azure VMs are on-demand, scalable computing resources that are available with Azure. An Azure VM provides the flexibility of virtualization. But it eliminates the maintenance demands of physical hardware. Azure VMs offer a choice of operating systems, including Windows and Linux.
A few alternatives to this architecture exist:
Keep the following points in mind when implementing this architecture.
This solution provides extended security updates for 2008 R2 versions of SQL Server and Windows Server for three years. Without extended support beyond that point, security breaches or data loss may result.
Windows Server 2008 R2 limits the number of nodes, or servers in the failover cluster, to 16.
The Azure shared disk feature only works with ultra disks and premium SSDs. Among those disk types, only certain disk sizes support sharing.
Use the Azure pricing calculator to explore the cost of running this scenario.