How to Create and Configure Load Balancer for AG Listener in MS Azure - SQL Server HA on Azure

How to Create and Configure Load Balancer for AG Listener in MS Azure

How to Create and Configure Load Balancer for AG Listener in MS Azure explains all below steps.

  1. How to create load balancer in Azure Portal?
  2. How to Configure Internal Load Balancer in Azure? 
  3. How to Configure FrontEndIP of Load balancer in Azure?
  4. How to configure backend pool in Load balancer in Azure?
  5. How to configure Health Probes in Azure?
  6. How to configure Load Balancer for Availability Group Listener in Azure?
  7. How to Configure AG listener port in Load Balancer in Azure? 
  8. How to Configure Cluster to use Load balancer in Azure?

Script Used in this video: 
$AG = Get-ClusterResource | Where-Object { $_.resourcetype -eq "SQL Server Availability Group" }
$Listener = Get-ClusterResource | Where-Object { $_.Name -like $AG.Name + "*" -and $_.resourcetype -eq "Network Name" }
$IP = Get-ClusterResource | Where-Object { $_.Name -like $AG.Name + "*" -and $_.resourcetype -eq "IP Address" }

Get-ClusterResource $IP.Name | Set-ClusterParameter -Multiple @{"ProbePort"="80";"OverrideAddressMatch"=1;}
Get-ClusterResource $Listener.Name | Set-ClusterParameter -Name "PublishPTRRecords" -Value 1
Get-ClusterResource $Listener.Name | Set-ClusterParameter -Name "HostRecordTTL" -Value 60


How to Create and Configure Load Balancer for AG Listener in MS Azure

5 comments:

  1. Excellent Post as always and you have a great post and i like it thank you for sharing


    โปรโมชั่นGclub ของทางทีมงานตอนนี้แจกฟรีโบนัส 50%
    เพียงแค่คุณสมัคร Sclub กับทางทีมงานของเราเพียงเท่านั้น
    ร่วมมาเป็นส่วนหนึ่งกับเว็บไซต์คาสิโนออนไลน์ของเราได้เลยค่ะ
    สมัครสล็อตออนไลน์ >>> goldenslot
    สนใจร่วมลงทุนกับเรา สมัครเอเย่น Gclub คลิ๊กได้เลย

    ReplyDelete
  2. This really helps. Thanks for posting this.

    ReplyDelete
  3. The essay is not always read, alas. Sometimes written work is needed "for show". However, it is on such jobs that you should learn - the ability to write my essay correctly express thoughts will still come in handy for you.

    ReplyDelete
  4. Often the okinawa flat belly tonic product is made up of lots of fuses which were very therapeutic for trimming back on abnormal bodyweight inside a few minutes. The product gets rid of stubborn fat deposits as well as all digestive system factors in a efficient direction. People with expectations to be aware of okinawa flat belly tonic in addition to points senses liberal to have a look at this valuable https://sargunjha1.wixsite.com/flat-belly-tonic
    web site.

    ReplyDelete
  5. Navigating the intricate relationship between technology and education requires nuanced exploration. Opting to buy term papers on this subject provides a comprehensive understanding of how technology shapes modern pedagogy. These papers delve into the transformative impact of digital tools, online learning platforms, and educational technology, offering valuable insights into the evolving landscape that is redefining the way we teach and learn.

    ReplyDelete