"MySQL Proxy is a simple program that sits between your client and MySQL server(s) that can monitor, analyze or transform their communication. Its flexibility allows for unlimited uses; common ones include: load balancing; failover; query analysis; query filtering and modification; and many more."
sounds like a cool idea. I cannot wait to tried it out. Cannot find a FC5 binary, so I downloaded a FC4 version a few days ago. Easy enough:
[vandba@cooler sbin]# ./mysql-proxy --help
mysql-proxy [OPTION...] - MySQL Proxy
-?, --help Show help options
--help-all Show all help options
--help-admin Show options for the admin-module
--help-proxy Show options for the proxy-module
--version Show version
However, when I trying to connect to it from another server. I can connect, but I cannot do anything.
mysql> show processlist;
LOL, boo. So I tried to download the source code to see if I can compile my own binary. No luck yet, cannot find it anywhere. The following link is broken: