Active/Passive NODE question

You could try using Manual Resume on the monitor. From the online help:

 

 

 

Specifies whether the system automatically changes the status of a resource to Enabled at the next successful monitor check. If you set this option to Yes, you must manually re-enable the resource before the system can use it for load balancing connections. The default is No.

 

 

* Yes: Specifies that you must manually re-enable the resource after an unsuccessful monitor check.

 

* No: Specifies that the system automatically changes the status of a resource to Enabled at the next successful monitor check.

 

 

 

Another option would be to use a db monitor to make a SQL query to a table that only returns a successful response if that SQL node is active.

 

 

Aaron