How to simulate loads on MySQL servers using Proxy and MockLoad

Lua script for Workbench to add relationships based on column names

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.