Forum Discussion

Pav_70755's avatar
Pav_70755
Icon for Nimbostratus rankNimbostratus
Sep 08, 2010

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...
application delivery
dev
devops
iRules
Pav_70755's avatar
Pav_70755
Icon for Nimbostratus rankNimbostratus
Sep 13, 2010
I've come up with something like this 

when CLIENT_ACCEPTED {
   if { [matchclass [IP::remote_addr] equals $::Wip_Server] and [TCP::local_port] != <1433> } {
      pool SQL-Wip
   }

But what would be better is if instead of redirecting on IP if I could just re-direct traffic based on the node?