MySQL Proxy: The Complete Tutorial (full day)

Giuseppe Maxia (Continuent), Jan Kneschke (MySQL)

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!

Photo of Giuseppe Maxia

Giuseppe Maxia

Continuent

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.

Photo of Jan Kneschke

Jan Kneschke

MySQL

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

  • MySQL Proxy,
  • lighttpd and
  • the wormhole Storage Engine.
Sponsors
  • Kickfire
  • Zmanda, Inc.
  • Continuent
  • EDS
  • JasperSoft
  • Sun Microsystems
  • Symantec Anti-Virus Software
  • XAware
  • Data Direct Technologies
  • Dolphin Interconnect Solutions
  • Hewlett Packard
  • Infobright, Inc
  • Linagora
  • Microsoft
  • OpSource
  • Oracle
  • Pentaho
  • R1Soft
  • Red Hat
  • Ticketmaster
  • TechRepublic

Contact Us

View a complete list of MySQL contacts.