MySQL Proxy, the Friendly Man in the Middle

MySQL Proxy evolved a lot since last years Birds of a Feather session. From a simple proof of concept to a production used component in the MySQL stack.

With is very simple core and integrated LUA-scripting the Proxy is able to handle a large set of use-cases from

• Query Rewriting (Schema Migration, Query Cache optimizations, ...)
• Query Injection (Query Analysis, auto grouping of INSERTs into Transactions, ...)
• Query Handling (Query Caching, ...)

to

• dynamic Load Balancing
• Connection Pooling
• Read/Write Splitting

In this overview session we want to present the concept and ideas behind the Proxy and give you an idea what you can use the proxy for your environment.