Forum Discussion
Ryannnnnnnnn
Altocumulus
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
Aug 10, 2018Cirrus
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.