Pav_70755
Sep 08, 2010Nimbostratus
SQL DNS RE-Direction
Hi Guys,
I basically have 3 SQL servers and a group of 6 web servers.
SQL Servers
SQL-Live
SQL-UAT
SQL-Wip
Web Servers
UAT
Wip
web1
web2
web3
web4
All web servers are in a pool
I have set them up as nodes on my F5 and I have 1 dns entry set up for sql dns entries which is sql-web.domain.com
what I want to do is be able to re-direct traffic to a specific sql server depending on which web server the SQL request comes from.
So in the code all i want to have is sql-web.domain.com and if this code is on the UAT web server i want the F5 to be able to re-direct this automatically to the UAT SQL server.
the web requests for my wip and uat servers dont go through the f5 but the live web servers are all set up on the F5 with sites as virtual servers using a the web pool of 4 live servers.
Any help would be much appreciated.
Pav