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.

MySQL Sandbox is a tool to install a side server or a replication system in seconds, in complete isolation, without need to remember complex sequence of commands.Administrators, developers, QA and support engineers need to install and test several versions of MySQL database server. Performing this task safely, without affecting existing instances on the same host is not easy. Using MySQL Sandbox, users can: Install a new server in less than 10 seconds, just by pointing to a binary tarball; Install an system of master + slaves in replication in less than 15 seconds; Install 10 independent servers in one minute with just one command; Optionally, install the above items with complex options, using one command, without need of editing configuration files. This presentation explain how to install a server or a replication system with MySQL Sandbox, covering the basics and some advanced  []

Stewart Smith, MySQL Cluster support at that time, introduces NDB (MySQL Cluster).

Brian Aker introduces EC2.

This is an IRC-only session in question-and-answer format (no need to connect to voice streaming). Please review the presentation slides prior to attending, and be ready to ask your questions during the session. Or better yet, enter your questions into the session page below so that our presenter can see them ahead of time and know what you're interested in!

This presentation will demonstrate how I setup an environment for building MySQL on Windows. While not strictly necessary, installing and running the Windows build system in a virtual machine allows for a single source repository to be shared among multiple flavors of Windows and/or other operating systems. We will focus on using only free or open source tools in the build environment, specifically we'll be using: VMWare Server, Microsoft Visual Studio Express 2005, Microsoft Windows Platform SDK, KitWare CMake, GNUWin32 Bison and Red Hat CygWin.

C++ coding techniques and principles

It is overview (not really very detailed) of insert/update/replace command execution: Important structures / files to understand command execution; Types of the commands; Every type execution in more detail

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.

Interaction Between Optimizer and Storage Engine

How to Run MySQL With a Debugger

How MySQL Handles ORDER BY, GROUP BY, and DISTINCT

In this talk, the developers behind MySQL Replication walk through some of the new Replication features of MySQL 5.1 and MySQL 6.0, such as: Row-based Replication (5.1) is used for MySQL Cluster replication and also provides a safer way to replicate non-deterministic statements. Row-based support for mysqlbinlog client (5.1) is used to analyze the row-based binlog entries. Row-based point-in-time recovery (5.1) is used to restore a server to a particular time point regardless of binlogging format. Heartbeating (6.0) is used to manage that the master and slave connection is always up. Semi-synchronous Replication (6.0) is used to ensure that any update of the master is on the slave before transaction is acknowleged to the user. Replication Server Filtering (6.0) ensures that the user can more easily replicate in a circle. Relay log synchronization (6.0) ensures that the slave is restartable without clearing the relay log in case of crashes.

If you need to play with a side installation of MySQL, you can use an extra host, or you can use MySQL Sandbox, and install as many as you want in just a few seconds. Come see the magic of an application that can save you time and resources. Single servers, circular, standard, and hierarchical replication, all is available at your fingertips with no effort! Furthermore, the latest version of MySQL Sandbox adds support for port checking, installing from a source directory, cloning, moving, preserving, and deleting sandboxes.

How to write MySQL test cases

How to write MySQL test cases

How to use character sets and collations properly

An overview of ZFS, and how to use the functionality of ZFS with MySQL, including performance improvements, to get the best out of ZFS.

MySQL coding style. Other coding styles around. How we can improve, and why we need to.

This session will give you an overview about how to perform backups of a MySQL Server using file system snapshots. Lenz will explain the general procedure, Caveats and Gotchas with this backup technique and how to work around some of them. The talk will also introduce two very popular methods for performing the actual snapshots: Linux LVM and using ZFS snapshots. Other utilities suitable for creating snapshot are covered as well.