top of page
  • Writer's pictureALIF Consulting

SQL Server 2008 R2 failover cluster in Azure

Updated: Dec 27, 2023

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:

Use Case

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.


Architecture


Azure load balancer

Key Components

  • 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.

  • SMB file share witnesses are servers that support the SMB protocol and host a file share. Failover clusters use these servers to provide high availability. When a site outage occurs, a file share witness provides an additional quorum vote that keeps the cluster running.

  • Azure shared disk is a feature of Azure managed disks. These shared disks offer shared block storage that multiple VMs can access. You can use this feature to attach a managed disk to multiple VMs simultaneously.

Alternatives

A few alternatives to this architecture exist:

Considerations

Keep the following points in mind when implementing this architecture.

Security considerations

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.

Scalability considerations

Windows Server 2008 R2 limits the number of nodes, or servers in the failover cluster, to 16.

Other considerations



102 views0 comments

Recent Posts

See All
bottom of page