F5 to load balance MS Sql Servers

I proposed a solution like this: (hope it works)

 

 

Create a VIP that will listen on 1433 (SQL Server Port) and will point at a pool with 2 servers of which at any given point only one will be active. The pool members may be running SQL on a different port, like 1437 or something (I hope it works, I never tried this but not sure if the VIP and the Pool Member service should be on the same port..sounds like I am missing basics here..).

 

Next thing is the trigger that makes the switch, which is a database table entry that F5 keeps polling for. Its a select statement and when a specific result is returned from the database, F5 needs to switch between nodes.

 

 

This is what I proposed for the business on the white board. Haven't tried this solution yet.

 

 

What do you think about this? Do you think it might work ? Do I need to make any major changes to this solution.

 

 

Thanks--Chenna