SQL Monitor question / problem...

Thank you - I see those fields, but I don't have the ability to modify the field at least not from the monitor page. It just says :

• All Addresses
  • All Ports

The only other way I can think of is to do an iRule.

I have a pool which is not actually connected to the VS. Assign monitor to that pool.

Then I could do an iRule which says, if MySqlServerPool has available members, then use this node, else use this other node.

It is a bit of a hack... and seems unnecessary, but it would probably work. Please let me know if there is a cleaner way to do it.

Any idea why I can't assign the alias address/port?

Here is my work around. It is not great because it's not intuitive, but it works.

when HTTP_REQUEST { if { [active_members MSSQLServerPool] == 0 } { node UseThisNodeIfTheMonitorIsDown:Port } else { node UseThisNodeIfTheMonitorIsUp:port } }

Just create a custom monitor using the parent SQL monitor. Then use the advanced settings to explicitly define the non-pool member IP and port via the alias config discussed above.

IT won't let me fill out the alias fields. They are not editable.

The fields should be editable if you create a new monitor and do as Ngutierrez31 said (select the relevant SQL monitor as the parent).

It looks like the fields are only editable when you create a new monitor for the first time . Once it has been created they cannot be modified.. That is what the problem was.