MySQL Proxy and Global Variables

[Edwin DeSouza]

MySQL Proxy and Global Variables

If you haven't checked out the MySQL Proxy yet, it is definitely worth playing with. One of the most useful features is the embedded Lua interpreter that allows a user such as myself to write scripts that modify queries and responses. Upon each connection to the proxy server, the Lua script is loaded and affects only that connection. Unfortunately my project requires logging over multiple connections (hard when each connections has its own instance of the script), but Jan was nice enough to add the PROXY.global feature. Now a single instance of my logging module can be used by multiple connections. So for your viewing pleasure, I am going to show you an example of how to use the globals in case you ever venture into using the proxy's embedded Lua interpreter.

http://cmcahoon.blogspot.com/2007/08/mysql-proxy-and-global-variables.html