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

6 comments:

  1. Yakru45May 27, 2019 at 8:50 PM

    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. UnknownApril 4, 2020 at 9:41 PM

    This really helps. Thanks for posting this.

    ReplyDelete
  3. SalvadorMay 25, 2021 at 3:42 AM

    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. KinbansayJune 13, 2021 at 9:00 AM

    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. Mirabella ChesterJanuary 29, 2024 at 1:18 PM

    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
  6. samNovember 13, 2024 at 10:23 PM

    Pro Function Health Care Team Pedorthics specializes in foot care solutions that support mobility, comfort, and overall foot health. Their expert team of certified pedorthists offers custom orthotics, footwear modifications, and specialized shoe fittings to help alleviate pain, improve alignment, and prevent foot injuries. With physiotherapy near me a focus on personalized care, Pro Function addresses various foot conditions such as plantar fasciitis, diabetic foot care, and arthritis.

    ReplyDelete

Subscribe to: Post Comments (Atom)