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

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.

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.

Roland Bouman takes the Sakila sample database and explains how to design and load a data warehouse for it, and how to use that to create those reports and charts that make managers smile. Along the way, he'll explain often uttered terms and concepts such as dimensional model, denormalization, star schema, OLAP, data staging, business intelligence, ETL and data integration. Roland's session is titled Starring Sakila - A Data Warehouse Mini-Tutorial.

This session gives an overview about how code contributions to MySQL should be handled and performed. It covers the ideal workflow, requirements and available infrastructure and toolchain that potential contributors should be aware of.

Tomas Ulin, MySQL Server Director, explains the new MySQL release model which has just recently been announced.

Databases grow every day more. It is not uncommon to accumulate 100 GB of historical data with an increasing performance problem. MySQL 5.1 with partitions can solve your problems quickly and painlessly in many cases. Using partitions, you can deal with several simple data warehousing cases in a transparent way.

Sheeri K. Cabral, a two-time winner of the MySQL Community Advocate award, passes the baton to the next generation of MySQL Community superheroes -- you! Though you cannot fly or have X-ray vision, Sheeri will explain how you can make a difference in the MySQL Community without writing a single line of code.

In the annual State of MySQL keynote, Karen Padir, Vice President for MySQL & Software Infrastructure at Sun Microsystems discusses the current and future role of MySQL in the modern online world. The presentation also covers the broader role MySQL plays at Sun, the role open source is playing for users and customers all over the planet, and what the visions for the future are.

A story of scaling, in today's world - using modern technologies like ZFS, OpenStorage, MySQL, and more, running one of the world's most popular photo sharing sites - SmugMug.

The inside story of MySQL use at Google, and how this performant database is scaled.

Perl stored procedures provide greater flexibility than the standard SQL stored procedures. For many users, they can provide performance and connectivity which is not available from the built in SQL implementation, where many users have to resort to writing UDFs.

Insights from the developers behind MySQL Partitioning. How is partitioning implemented, how does it work in the server and with the storage engines? What solutions can it be a part of and what problems does it introduce? We present a new partitioning type: Column list, range partitioning on any column type. And give the status of the current development.

This session will present the latest connector developed by SUN - MySQL Connector/C++.

ZFS offers many leading-edge features, including automatic protection against silent data corruption, immense capacity, and vastly simplified administration. But how well does it perform with MySQL? This session explores MySQL performance with ZFS compared to alternative file system implementations. The performance implications of ZFS compression and other features are also examined.

The MySQL Replication developers walk through some of the new Replication features of MySQL 5.1 and MySQL 6.0, such as row-based replication, heart-beating and semi-synchronous replication.

The goal of this session is to introduce users to new standard conforming and engine-neutral implementation of foreign keys, which is being developed for 6.1 version of server. The session will describe capabilities of this new implementation (including limitations for different engines), give a glance at its performance and provide comparison with current InnoDB-specific implementation.