Mysqlconf 2009 talk about Kickfire

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.

Innovation happens everywhere; MySQL drives innovation within support to serve customers better. Considered one of the best, we'll show off how MySQL Support works around the clock, around the globe. This talk could be useful for startups trying to build services for their customers and community. We'll show the tools we are using and how support engineers communicate internally with each other.

mysqlnd, also known as MySQL native driver for PHP, is the new way of connecting from PHP to MySQL. It's a superior substitute to libmysql. mysqlnd is "native" to PHP, in means that it uses the infrastructure provided by PHP. In this session I will show why mysqlnd is better than libmysql, in the PHP world - performance, better resources utilization, quicker bug-fixing cycle and others.

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.

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.

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.

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.

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.

An overview how to make MySQL host system more secure, MySQL itself hardened, access control impossible to penetrate and use all possible security features MySQL provides. Additionally, it will cover some of security design flaws, that can be best resolved by hacking MySQL itself.

Recently faced with the problem of an ordinary table growing too large to back up or maintain, we designed a MySQL-Proxy-based storage cluster which seamlessly integrates with the rest of the database and offers redundancy, cluster-member failure protection, load balancing, and information lifecycle management (data age-out) capabilities.

See the replication developers give you a fast-paced session of some of the more interesting, useful, and odd ticks available for the intermediate to advanced replication user.

How do you set up replication? What can you do with replication? If these are the kinds of questions you ask yourself, then you need to go to this replication tutorial. You will hear the replication developers explain the architecture and concepts behind replication, and learn how to configure and use replication for managing backups, handle high-availability, and performing scale-out.

Discussion on solid state disk and how it will change the high performance industry. View pretty graphs and benchmarks that will dazzle your eyes, with numbers sure to get the purest database performance geek excited. DBT2, sysbench, Orion, and other benchmarks will help highlight the advantages and disadvantages of this new and exciting technology.

There are many different ways of scaling up and scaling out using MySQL. You can take advantage of replication, DRBD, memcached, MySQL Proxy and many other solutions. This tutorial will take you through all of these solutions and their combinations to increase your database throughput.

MySQL security best practices often assume restricted access to the physical server and restrictive file system privileges. However, OEM's and ISV's who bundle and distribute their application with MySQL have no control over where the application is installed. This session will provide silent installation instructions, common deployment strategies and recommendations for securing your data.