Is it possible to run a SQL query and depending on the result put a pool member up or down? The problem here is that the SQL query is not running against the pool member.

Yes. Both the MSSQL and MySQL monitors have fields where you can put an alias address (the address of the SQL server you want to check) and depending on whether the check is successful or not your pool member(s) will be marked UP/DOWN.

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.

SQL Monitor question / problem...

18 Replies

Ryannnnnnnnn
Altocumulus
Aug 10, 2018
Yes. Both the MSSQL and MySQL monitors have fields where you can put an alias address (the address of the SQL server you want to check) and depending on whether the check is successful or not your pool member(s) will be marked UP/DOWN.
- patonbike
  Cirrus
  Aug 13, 2018
  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.
- Ryannnnnnnnn
  Altocumulus
  Aug 13, 2018
  The fields should be editable if you create a new monitor and do as Ngutierrez31 said (select the relevant SQL monitor as the parent).
- patonbike
  Cirrus
  Aug 11, 2018
  IT won't let me fill out the alias fields. They are not editable.
Ryan_80361
Cirrostratus
Aug 10, 2018
Yes. Both the MSSQL and MySQL monitors have fields where you can put an alias address (the address of the SQL server you want to check) and depending on whether the check is successful or not your pool member(s) will be marked UP/DOWN.
- patonbike
  Cirrus
  Aug 13, 2018
  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.
- Ryan_80361
  Cirrostratus
  Aug 13, 2018
  The fields should be editable if you create a new monitor and do as Ngutierrez31 said (select the relevant SQL monitor as the parent).
- patonbike
  Cirrus
  Aug 11, 2018
  IT won't let me fill out the alias fields. They are not editable.