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

4 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

Subscribe to: Post Comments (Atom)