MySQL Forge

Resources for the MySQL Community

View source

This page has been locked to prevent editing.

You can view and copy the source of this page:

[[Category:MySQLProxy]] [[Image:Sakila_proxy_256x298.jpg|left]] __TOC__ = The MySQL Proxy Cookbook = == Overview == == How to contribute == # Post your code as a [http://forge.mysql.com/tools/ Forge snippet]; # Create a wiki page to explain what your module does and how to use it; # post a link to the snippet and the documentation in this page, with a short description. == Recipes best practices == === OS matters === * If your recipe is OS specific, make it evident in the title itself. For example, a trick to redirect the proxy port using iptables should be titled "redirecting Proxy Port in Linux". * If your recipe requires OS access before or after using the Proxy, such as creating auxiliary files or getting parameters from unusual places, try to avoid OS specific shell scripts. Your recipe would be much more valuable if it is all written in Lua. === Code style === == Cookbook == === Basics - tutorials === * [http://forge.mysql.com/tools/tool.php?id=75 Basic query interception] * [http://forge.mysql.com/tools/tool.php?id=76 Query rewriting] * [http://forge.mysql.com/tools/tool.php?id=77 Injecting queries] * [http://forge.mysql.com/tools/tool.php?id=78 Returning a dataset] === OS interaction === * [http://forge.mysql.com/tools/tool.php?id=79 Executing shell commands] * [http://forge.mysql.com/tools/tool.php?id=80 Simple query logging] * [http://forge.mysql.com/tools/tool.php?id=81 Query logging with result info] === Syntax enhancements === * [http://forge.mysql.com/tools/tool.php?id=96 Loop with a counter or through a list] === Monitoring and logging techniques === * (TODO) Basic - Use a Proxy to dump packet contents to the screen, watching a server activity * [http://forge.mysql.com/tools/tool.php?id=133 Log warnings and errors into a MySQL table] * (TODO) Intermediate - Use a Proxy to log SHOW STATUS values to a file after each query, while another program charts the trend. * (TODO) Advanced - Use a packet-dumping Proxy to debug the traffic of another Proxy, to test lua script development.) * (TODO) Advanced - Use a Proxy between master and slaves to monitor replication traffic * (TODO) Guru - Use a Proxy between master and slaves to supervise master fail-over. === Linux specific recipes === * [http://forge.mysql.com/tools/tool.php?id=82 Redirect the proxy port on Linux] Got a juicy example? Add it to this list! ---- work in progress ----

Return to Main Page.