top of page
Image by Thought Catalog

Post Details

  • Writer's pictureALIF Consulting

SQL Server 2008 R2 failover cluster in Azure

Updated: Oct 26, 2022

About Alif: Alif empowers Microsoft MSP-CSP partners to provide exceptional IT services to their clients to ensure that the partners reduce their costs and focus on their business. We provide white-labelled managed services for technologies like Microsoft Azure, Microsoft 365, Microsoft Dynamics 365, Microsoft Security, SharePoint, Power Platform, SQL, Azure DevOps and a lot more. Our headquarter is in Pune, India whereas we work with over 50 partners across the globe that trust us with their client delivery.


SQL Server 2008 R2 failover cluster in Azure


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



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 -



59 views0 comments

Recent Posts

See All
bottom of page