Install and configure SQL AlwaysON AG with Listener on Azure

Creating the Load Balancer

Create the load balancer

Login to Azure and go directly to the load balancer page here: Load Balancers

load_balancer_step_1
Click on Add
load_balancer_step_2
Enter a cool and or descriptive name for the load balancer. Click on Internal for the scheme.
load_balancer_step_3
Click on Choose a virtual network and select the vnet
load_balancer_step_4
Click on Choose a subnet and select the appropriate subnet.
load_balancer_step_5
For IP address assignment, select Static. Enter a static IP that corresponds to the subnet. Click Create

Configuring the load balancer:

load_balancer_step_6
Click on the newly created loadbalancer.
In order, we will need to create the following:

  • Backend Address Pool
  • Probe

Load balancing rule.

load_balancer_step_7
Click on Backend Pools
load_balancer_step_8
Click on Add
load_balancer_step_9
Important to note: Azure scrolls sideways and not up / down.
Enter a cool and or descriptive name for the Backend pool. Select Availability Set > Choose the relevant availability set.
load_balancer_step_10
Click on Virtual Machines > Select 2 or more virtual machines. Click Select
load_balancer_step_11
Click OK
load_balancer_step_11
You can see the new change highlighted on the left.
load_balancer_step_12
Click on Probes. Enter a cool and or descriptive name for the Probe. Select TCP (or leave on HTTP). Enter a port (I chose 59999 as this is listed on most Microsoft posts – so I can only assume its a listening port configured on VMs by default in Azure)
load_balancer_step_13
You can see the new change highlighted on the left.
load_balancer_step_14
Select Load balancing rules > Add > Enter a cool and or descriptive name for the Load balancing rule. Enter the port, and because this is for the listener, we need a floating IP – select this option. Once this option is selected and saved, it CANNOT be changed. The rule will need to be deleted and recreated. Click OK
load_balancer_step_15
You can see the new change highlighted on the left.
load_balancer_step_16
Now the load balancer has been created, we’re ready to go to the next step.

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*