MySQL Proxy Cookbook
Contents |
The MySQL Proxy Cookbook
Overview
How to contribute
- Post your code as a 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
OS interaction
Syntax enhancements
Monitoring and logging techniques
- (TODO) Basic - Use a Proxy to dump packet contents to the screen, watching a server activity
- 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
Got a juicy example? Add it to this list!
work in progress