Advanced Query Manipulation with MySQL Proxy Kay Roepke (Sun Microsystems) From the official conference description at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7040 Currently MySQL Proxy only comes with an incomplete tokenizer for a subset of the MySQL dialect. Many use cases require more knowledge about the query that a stream of tokens can provide and users are force to create their own parsers, most of which are handwritten and simplistic, in Lua. While this is often sufficient for special cases and specific applications, it cannot serve as an extensible and robust framework. For the purpose of query formatting in the MySQL Enterprise Monitor I have written a new parser using ANTLR, where I am a committer in the project. Due to the nature of ANTLR generated recognizers, it is possible to target different implementation languages with little effort and thus has been integrated with  []

One of the most frequently needed functionality in the MySQL Proxy is the need to know which server you are on. This is not given, on purpose, by the proxy, because the proxy is supposed to be transparent. It is not supposed to matter which back-end server you are on.However, for testing purposes we often want to know which back-end server we're on. Thus I developed functionality for "SHOW PROXY BACKEND [INDEX ADDRESS OTHER]"."SHOW PROXY BACKEND INDEX" -- gives t

"mysql-proxy" defaults to round-robin load balancing. There are fancy tricks around to get "mysql-proxy" to balance connections based on how many idle connections there are in a proxy-based connection pool. But there is no code that I found that would simply load balance based on "always go to one server, go to another server only when the first server is down."Well, I spent way t

MySQL users often dream about a more powerful yet stable database server. They want a server with more features, like expanding macros, customized logging, access to shell commands, access to live tables from other DBMS. Every feature, given enough development time, can be eventually implemented, but users want them now, with the current GA server. It can be done. Using a proxy server, some of those dreams come true. Today.

Jan Kneschke, creator of MySQL Proxy, gives an overview of the architecture and usage of MySQL Proxy.

This talk will cover the advanced Lua script methods. So you must have attended the basic session and be acquainted with the mechanics of Proxy scripting. Having learned the basic of Lua programming for Proxy, some advanced topics can be covered. This session will explain how to tackle some difficult tasks with the Proxy, organizing your work so that you can create a new script in minutes: using a script loader to change script at run time, without restarting; creating new commands; creating quick methods for returning datasets and error messages to the client; executing multiple commands in the Proxy, while returning only one result to the client; chaining more scripts to extend Proxy features.

This session will introduce the basics of Lua language, with particular emphasis on the features of immediate use with MySQL Proxy. The lecture will include with a few examples of growing difficulty, commented in depth.

A collection of MySQL cartoons, featuring Sakila in several environments. Includes images for LAMP, Java, performance, Proxy, Forge, Security, University, Speaker, Writer, traveler, wizard, Summer of Code, and the Librarian.