Database Servers LoadBalancing

I have three Microsoft SQL Database servers and want to load balance them using BigIP. This load balancing won’t be a load balancing in actual because i need only 1 Node active in the whole process.

 

 

Getting into depth, the scenario is like this –

 

Servers – 3 (db1, db2, db3)

 

Load Balancing Algorithm - any one

 

 

What we want to achieve –

 

 

1) I want to use mssql monitor to continuously monitor all the three nodes, with a database query & return string check.

 

 

2) I want to take a particular node down, if the database query string returns a particular value (ex. If a query {Select name from } returns xyz, then I would like to take that particular node down. (Only Active connections would be allowed and new connections would be redirected to other node)

 

 

 

Please let me know if the above is possible.