Forum Discussion

lardyboy_lardyb's avatar
lardyboy_lardyb
Icon for Nimbostratus rankNimbostratus
Oct 06, 2005

control state of pool based on different server status

quick one

 

 

we have a requirement to enable / disable a pool based on the outcome of a MSSQL monitor against a server not in that pool. is it possible with an iRule to to do this type of multi-level monitor?

 

 

ultimately, we would like to disable the pool if the MSSQL monitor fails, but still load balance based on the pool checks for HTTP etc.
application delivery
dev
devops
iRules
  • Brian_Gupta_115's avatar
    Brian_Gupta_115
    Icon for Nimbostratus rankNimbostratus
    Oct 08, 2005
    This doesn't require an iRule.

     

     

    Create a specific MSSQL monitor for this purpose. In the alias address field of the monitor hardcode the IP of the MSSSQL server you wish to monitor.

     

     

    After you have saved this monitor add it as a pool healthcheck list. (You will need to still keep an HTTP healthcheck in place to monitor the nodes in the pool. Make sure that "Availibility requirement" is set to "(All) Health Monitor(s)"

     

     

    The traffic will still be loadbalanced based on the loadbalancing algorithm you setup for the VIP.

     

     

    -Brian

     

     

    P.S. - I've never tried this, but it should work.