Random Query Generator is a new QA tool that generates pseudo-random queries targeted to exercise a specific part of the server being tested. It then executes those queries to check for crashes or assertions or to compare the results returned from two different servers (two versions, two different storage engines, optimizer flags, etc.). It is also able to execute queries against a replication master, constantly checking that the slave is OK and has not diverged.

Sergey from the MySQL Optimizer team talks about recent developments in the MySQL Optimizer, including: What's new in MySQL 5.1 optimizer, Overview of known optimizer problems in MySQL 5.1, State of new optimizations in MySQL 6.0, Optimizer development beyond 6.0

Run-through of PHP and Database support in NetBeans

OpenSolaris Web Stack (http://opensolaris.org/os/project/webstack) is an OpenSolaris project and community building an integrated stack of popular open source web tier infrastructure technologies such as Apache HTTP server, MySQL, memcached, PHP and Ruby On Rails optimized for Solaris platform. This session introduces OpenSolaris Web Stack, its status and future development including addition of newer technologies such as lighttpd, Varnish etc., as well as the ease of use features for developers and deployers. We will also be discussing an experimental web stack IPS package repository and it could be leveraged to build and make available popular end user applications such as Drupal.

Building MySQL client applications

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.

How to write MySQL test cases

How to write MySQL test cases