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
ryanc_76025's avatar
ryanc_76025
Icon for Altocumulus rankAltocumulus
Jan 22, 2009
This, unfortunately, isn't going to work so easily...I really wish it did, but it won't.

 

 

The main problem is very close to what hoolio guessed at, the actual SELECT statement in MySQL comes only after the initial handshake, server welcome, client authentication, and subsequent information from the server about it's capabilities.

 

 

At the bottom is a link to the MySQL Server/Client Protocol wiki page. You are definitely headed down the right road, but you've got to convince the client that it is talking to a real MySQL server.

 

 

http://forge.mysql.com/wiki/MySQL_Internals_ClientServer_Protocol