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.

Developing MySQL on Solaris requires you to install a suitable compiler and other tools, but you may be surprised to know that most of the material is there already, or easy to install if it's not. But even more so, there is a huge wealth of information that you can get about your application while it's running, both with and without using more traditional debugging methods. We'll cover setting up a suitable environment, where to find the things you need, and and how to make use of the process monitoring tools and debugging environment to get the best out of development on Solaris generally, and MySQL specifically.

Using DTrace with MySQL - current state, future prospects, and lots of examples

Allan Packer from Sun Labs outlines 2009 plans for improving MySQL performance on multi-core systems.

This session describes investigations into performance and scalability of InnoDB when using the binlog for replication, focusing primarily on the replication master. The session will highlight tools and techniques used to reveal scalability bottlenecks within the MySQL and InnoDB code, approaches used to eliminate those bottlenecks, and current results. The discussion will focus on a current prototype patch that achieves substantial throughput increases for read/write workloads, and enables concurrent commits for InnoDB XA transactions. - Note that the video must be downloaded to be able to view it!

Richard Smith from Sun Labs explains how to code for multi-core systems.

Tim Cook from Sun Labs explains issues and opportunities with locking in InnoDB. - Note that the video must be downloaded to be able to view it!

Memcached, and how it fits into the typical MySQL environment. - Note that the video must be downloaded to be able to view it!

Using, installing and working with MySQL on OpenSolaris. - Note that the video must be downloaded to be able to view it!

Are you starting a new software project? Don't reinvent the wheel. Before committing to some hand made procedure, you should really consider the combination of Bazaar and Launchpad. Handling the source code is not enough. A software project requires planning, defect handling, coordination between bugs and blueprints, a visual roadmap, and all the above in relation to your code branches. Don't forget about mailing lists, FAQ, documentation, which are integral part of a project. Whether you are participating to an existing project or starting a new one, Launchpad and Bazaar are a powerful combination for your productivity.

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.

Since you're reading this, you probably know that Sun is switching to the Bazaar version control system for all development work on the MySQL server. Unlike the version control system that we've been using previously, Bazaar is an open source project and freely available to anyone. This means that it is now much easier to follow ongoing development, or even to participate in it! On the downside, just like our previous tool, Bazaar is not quite as straight-forward as traditional version control systems such as CVS or subversion. The aim of this article is to give an overview and a general idea of how to set up Bazaar, how to access the MySQL server source code repositories, and the basic commands for working with the source code.

The MySQL project switched from Bitkeeper to another revision control system, Bazaar, in June 2008. My colleague Daniel Fischer wrote an excellent article describing how to get MySQL's code by using Bazaar, and how to compile a MySQL server binary from this. Here I am going to build on this knowledge and take it further, to show you how to modify MySQL's code for your needs, and share your modifications.

When I joined MySQL back in June of 2005, one of the first “MySQL Truths” I learned and repeated often when discussing MySQL with others was “release early, release often.” If you’ve been using MySQL for any length of time, you know what that statement means – it meant that MySQL was: (1) dedicated to getting new features and enhancements into the hands of its community so the software’s quality could be validated; (2) eager to take early feedback on those features so the input could rapidly be incorporated back into the product allowing everyone to benefit; (3) committed to very frequent releases of the software so helpful new features and/or external contributions that were ready for action could quickly be put into play and not sit idle on the shelf. And if you’ve been around Open Source for a while now, you know this is the spirit in which most providers of Open Source software operate.

An introduction to Gearman (a client/server infrastructure for distributed workers) and its practical application to replication setup. By combining the ease of use of MySQL Sandbox and the flexibility of Gearman, you can ger remote replication setup with low risk of mistakes.

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.