Forum Discussion
wowchens
Feb 07, 2008Nimbostratus
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