For more information regarding the security incident at F5, the actions we are taking to address it, and our ongoing efforts to protect our customers, click here.

Forum Discussion

myocella's avatar
myocella
Icon for Nimbostratus rankNimbostratus
Jan 22, 2009

iRule to inspect MySQL statements

Greeting,     I would like to create iRule to apply a VS to redirect MySQL traffic   to a pool based on the SQL statement. Here is my iRule:     ---------------8<-----------...
application delivery
dev
devops
iRules
hoolio's avatar
hoolio
Icon for Cirrostratus rankCirrostratus
Jan 22, 2009
If you capture a tcpdump, do you see the client sending any data? I'm not sure about mysql, but maybe the client establishes the connection and then waits for the server to send data first? That's just a stab in the dark though. If this is the case, take a look at the TCP::collect wiki page's section on skip bytes (TCP::collect Click here).

 

 

Aaron