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:
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!
Giuseppe Maxia, a.k.a. “The Data Charmer” works as QA Director at Continuent.
He’s an active member of the MySQL community and long timer open source enthusiast.
During the past decades he has worked in various IT related fields, with focus on databases, object oriented programming, system administration.
Fluent in Italian, English, Perl, Python, SQL, Lua, C, Bash, and good speaker of C++, French, Spanish, Java.
Works in cyberspace, with a virtual team.
Jan Kneschke works for Sun as Senior Software Developer in the MySQL Enterprise Tools team and maintains the MySQL Proxy and the agent component of MySQL Enterprise Monitor.
His favourite programming language is Lua as you can see in the
View a complete list of MySQL contacts.