The MySQL Proxy documentation is in place!
The MySQL Proxy is an application that communicates over the network using the MySQL Network Protocol and provides communication between MySQL servers and MySQL clients. In the most basic configuration, MySQL Proxy simply passes on queries from the client to the MySQL Server and returns the responses from the MySQL Server to the client.
By intercepting queries from the client, the Proxy can insert additional queries into the list of queries sent to the server, and remove the additional results when they are returned by the server. Using this functionality you can add informational statements to each query, for example to monitor their execution time or progress, and separately log the results, while still returning the results from the original query to the client.
The proxy allows you to perform additional monitoring, filtering or manipulation on queries without you having to make any modifications to the client and without the client even being aware that it is communicating with anything but a genuine MySQL server.
The MySQL Proxy is available for MySQL servers 4.1 or better and is documented in these MySQL Reference Manuals:
*
http://dev.mysql.com/doc/refman/5.1/en/mysql-proxy.html
*
http://dev.mysql.com/doc/refman/5.0/en/mysql-proxy.html
*
http://dev.mysql.com/doc/refman/4.1/en/mysql-proxy.html
It's also available in various download formats from the MySQL documentation overview page (http://dev.mysql.com/doc).
Stefan Hinz, MySQL Documentation, Berlin, Germany
Edited 1 time(s). Last edit at 08/29/2007 09:17AM by Jim Winstead.