MySQL Proxy: The Complete Tutorial (full day)

MySQL Proxy is a lightweight application that sits between a MySQL client and a server. This unique position allows you to define new features and enhance the existing ones. Using MySQL Proxy you can create new commands, filter unwanted queries, enforce security, detour traffic to replicated servers, and obtain on-the-fly statistics. All without waiting for MySQL developers to do the features for you. And no C/C++ required!

This tutorial will show how the techniques for the main features using MySQL Proxy:

• creating a new SQL command;
• intercept and change an unwanted query;
• getting statistics and tuning information on your queries;
• using a proxy for debugging;
• using the Proxy for improve testing;
• Using Proxy with multiple servers

The tutorial will be divided in two parts:

The first part will cover the overview of MySQL Proxy, the basics of Lua language, and how to create new SQL features. The second part will cover the usage of Proxy with multiple servers and with replication, testing, tuning, and debugging techniques.

Users attending this tutorial will learn the Do-It-Yourself of creating some simple proxy scripts, and of interacting with the Proxy in a replicated environment.

Get ready for a wonderful trip to Proxyland!