MySQL Conference & Expo 2011 Schedule

Below are the confirmed and scheduled talks at MySQLConf 2011 (schedule subject to change).

Customize Your Own Schedule

Create your own MySQLConf schedule using the personal scheduler function. Mark the tutorials, sessions, keynotes, and events you want to attend by clicking on the calendar icon [calendar icon] next to each listing. Then click on "personal schedule" below and get your own customized schedule generated.

Ballroom A
Add MySQL to Drizzle, stress free migration to your personal schedule
10:50am MySQL to Drizzle, stress free migration Andrew Hutchings (Hewlett-Packard)
Add SkySQL Enterprise Monitor to your personal schedule
2:50pm SkySQL Enterprise Monitor Ivan Zoratti (SkySQL)
Ballroom B
Add Deploying MySQL & Drizzle in the Cloud with chef to your personal schedule
10:50am Deploying MySQL & Drizzle in the Cloud with chef Padraig O'Sullivan (Akiban Technologies Inc.)
Add Mysql Data Warehousing – A Survival Guide	 to your personal schedule
11:55am Mysql Data Warehousing – A Survival Guide Marius Moscovici (Metric Insights Inc.), Steffan Mejia (Linden Lab)
Add A code stub generator for MySQL and Drizzle plugins to your personal schedule
2:00pm A code stub generator for MySQL and Drizzle plugins Hartmut Holzgraefe (...???...)
Add Making MySQL Better for the Data Center to your personal schedule
2:50pm Making MySQL Better for the Data Center Mark Callaghan (Facebook), Ryan Mack (Facebook), Vamsi Ponnekanti (Facebook)
Ballroom C
Add InnoDB: Status, Architecture, and Latest Enhancements to your personal schedule
10:50am InnoDB: Status, Architecture, and Latest Enhancements Inaam Rana (Oracle), John Russell (Oracle Corporation)
Add Forecasting MySQL Performance and Scalability to your personal schedule
11:55am Forecasting MySQL Performance and Scalability Baron Schwartz (VividCortex)
Add Scaling MySQL in the Cloud to your personal schedule
2:00pm Scaling MySQL in the Cloud Moshe Shadmon (ScaleDB)
Ballroom D
Add OQGRAPH: Dealing with Graphs and Hierarchies in Plain SQL to your personal schedule
10:50am OQGRAPH: Dealing with Graphs and Hierarchies in Plain SQL Antony Curtis (Blizzard Entertainment)
Add Summary Tables, Aggregate Tables and Materialized Views Using Flexviews to your personal schedule
2:50pm Summary Tables, Aggregate Tables and Materialized Views Using Flexviews Justin Swanhart (Percona), Ryan Lowe (Percona)
Ballroom E
Add Metadata locking and deadlock detection in MySQL 5.5 to your personal schedule
11:55am Metadata locking and deadlock detection in MySQL 5.5 Konstantin Osipov (MySQL)
Add Engineering MySQL Subroutines for Integrity to your personal schedule
2:00pm Engineering MySQL Subroutines for Integrity Michael McLaughlin (BYU - Idaho)
Ballroom F
Add Galera Replication to your personal schedule
10:50am Galera Replication Seppo Jaakola (Codership), Alexey Yurchenko (Codership)
Add A State of Multi-Master Replication to your personal schedule
11:55am A State of Multi-Master Replication Seppo Jaakola (Codership), Alexey Yurchenko (Codership)
Add Using Sphinx Beyond Full Text Search to your personal schedule
2:00pm Using Sphinx Beyond Full Text Search Peter Zaitsev (Percona Inc), Richard Kelm (Sphinx Search)
Ballroom G
Add BLOB Data And Thinking Out Side The Box to your personal schedule
10:50am BLOB Data And Thinking Out Side The Box Barry Leslie (PrimeBase Technologies), Volker Oboda (PrimeBase Technologies GmbH)
Add Fulltext Searching with a Groonga Storage Engine to your personal schedule
2:00pm Fulltext Searching with a Groonga Storage Engine Tetsuro Ikeda (Sumisho Computer Sytems Corporation), Kentoku SHIBA (WildGrowth), Daijiro MORI (brazil), Tasuku SUENAGA (Brazil, Inc.)
Add Upgrading MySQL: Best Practices to your personal schedule
2:50pm Upgrading MySQL: Best Practices Peter Zaitsev (Percona Inc)
Ballroom H
Add Performance Tuning for Drizzle to your personal schedule
11:55am Performance Tuning for Drizzle Monty Taylor (HP)
Add Fixed in Drizzle: No more "GOTCHA's" to your personal schedule
2:00pm Fixed in Drizzle: No more "GOTCHA's" Stewart Smith (Percona)
Add Performance comparisons and trade-offs for various MySQL replication schemes to your personal schedule
2:50pm Performance comparisons and trade-offs for various MySQL replication schemes Darpan Dinker (Schooner Information Technology, Inc.), Brian O’Krafka (Schooner Information Technology)
Add Building on Strengths, Learning from Differences to your personal schedule
9:00am Plenary
Room: Ballroom EFGH
Building on Strengths, Learning from Differences Baron Schwartz (VividCortex)
Add The Next Decade in Data Management to your personal schedule
9:30am Plenary
Room: Ballroom EFGH
The Next Decade in Data Management Mike Olson (Cloudera)
Add Best of Ignite to your personal schedule
10:00am Plenary
Room: Ballroom EFGH
Best of Ignite
Add Big and Small Data at @Twitter to your personal schedule
3:50pm Closing Keynote
Room: Ballroom EFGH
Big and Small Data at @Twitter Jeremy Cole (Twitter)
10:20am Morning Break
Room: Ballroom Foyer
3:35pm Afternoon Break
Room: Ballroom Foyer
Add Ice Cream Social Closing Reception to your personal schedule
4:35pm Ice Cream Social
Room: Ballroom Foyer
Ice Cream Social Closing Reception
12:40pm Lunch
Room: Pool Area & Santa Clara Ballroom
10:50am-11:50am (1h) Drizzle
MySQL to Drizzle, stress free migration
Andrew Hutchings (Hewlett-Packard)
A guide to migrating your database and application from MySQL to Drizzle at every layer, from schemas to connections and application modifications.
11:55am-12:40pm (45m) NoSQL
Using CouchDB for Emerging World Healthcare Solutions
Cory Zue (Dimagi)
People talk about NoSQL in the context of distributed cloud-based web applications, but what if your application needs to be deployed throughout rural Africa, with limited computer resources, intermittent power, and above all, extremely unreliable internet? This talk discusses the features of CouchDB that make it uniquely suited for developing world health applications.
2:00pm-2:45pm (45m) Replication and Scale-Out
Error Detection and Correction with MySQL Replication
Daniel Peek (Facebook)
MySQL replication has been a critical part of scaling Facebook's storage infrastructure.  However, it brings with it the fear of divergent replicas.  This session discusses a new tool that detects divergences, identifies inconsistent data, and helps repairs defects.  
2:50pm-3:35pm (45m)
SkySQL Enterprise Monitor
Ivan Zoratti (SkySQL)
The webyog monitor, how to use it, what it's good at etc.
10:50am-11:50am (1h) Drizzle
Deploying MySQL & Drizzle in the Cloud with chef
Padraig O'Sullivan (Akiban Technologies Inc.)
In this presentation, we will cover how to easily deploy MySQL and Drizzle databases on Amazon and the Rackspace cloud using chef. In particular, Drizzle is a database designed specifically for the cloud and we will discuss how its modular architecture benefits deployment.
11:55am-12:40pm (45m) Data Warehousing and Business Intelligence
Mysql Data Warehousing – A Survival Guide
Marius Moscovici (Metric Insights Inc.) et al
This presentation provides architectural guidance, design patterns, and specific suggestions for deploying and administering Data Warehouses using Mysql. It is based on lessons learned building and operating a Multi-Terabyte Mysql 5 Data warehouse over a period of 5 years.
2:00pm-2:45pm (45m) Drizzle, PHP and MySQL, Storage Engine Development and Optimization
A code stub generator for MySQL and Drizzle plugins
Hartmut Holzgraefe (...???...)
Writing a complete plugin requires quite a bit of infrastructure work to get all the feature registration and build system aspects right. A code generator can take care of such tasks, allowing you to focus on the actual functionality you want to add without having to figure out all plugin API details up front. This can cut the time to create a simple plugin down from hours to minutes.
2:50pm-3:35pm (45m) Replication and Scale-Out, Storage Engine Development and Optimization
Making MySQL Better for the Data Center
Mark Callaghan (Facebook) et al
The Facebook database engineering team works with the community and on its own to make MySQL better for data center deployments. This work is visible in the Facebook patch, bugs fixed in official MySQL and features sponsored in other distributions. We will describe work to support a large number of large databases. We focus on backup, replication and quality of service.
10:50am-11:50am (1h) Storage Engine Development and Optimization
InnoDB: Status, Architecture, and Latest Enhancements
Inaam Rana (Oracle) et al
InnoDB becomes the default storage engine in MySQL 5.5. At this session, you will learn the current state of InnoDB and the latest enhancements to the InnoDB storage engine in MySQL 5.5; plus how InnoDB works.
11:55am-12:40pm (45m) Performance Tuning and Benchmarking
Forecasting MySQL Performance and Scalability
Baron Schwartz (VividCortex)
This talk shows you how to gather the correct data for performance forecasting and capacity planning. You will learn how to apply mathematical models to the data, and get meaningful answers that are likely to resemble reality.
2:00pm-2:45pm (45m) Architecture and Technology, Cloud Computing, Data Warehousing and Business Intelligence, MySQL Cluster and High Availability, Performance Tuning and Benchmarking, Replication and Scale-Out, Storage Engine Development and Optimization
Scaling MySQL in the Cloud
Moshe Shadmon (ScaleDB)
ScaleDB is a pluggable storage engine for MySQL. It turns MySQL into an enterprise-class, highly-available, clustered database that scales dynamically in a public and private cloud.
2:50pm-3:35pm (45m) Drizzle
Introducing kewpie - a feedback-based query generation and testing framework
Patrick Crews (HP Cloud Services)
Kewpie is a random testing tool for database systems. Based on research by Microsoft's SQL Server team, it utilizes feedback from the system under test to help drive query generation. This design provides a greater degree of control and accuracy than purely random systems. This talk will discuss the motivations behind the system as well as providing several applications for testing.
10:50am-11:50am (1h) Architecture and Technology, Web 2.0, Ajax, and Emerging Technologies
OQGRAPH: Dealing with Graphs and Hierarchies in Plain SQL
Antony Curtis (Blizzard Entertainment)
Antony shows the OQGRAPH engine in MariaDB 5.2, allowing you to deal with graphs (networks) for social networking, hierarchies and other complex structures, all in plain clean SQL.
11:55am-12:40pm (45m) MySQL Cluster and High Availability
InnoDB vs MySQL Cluster: Which Storage Engine Is Right For You?
Ivan Zoratti (SkySQL)
MySQL Cluster (NDB) is one of the most interesting storage engines. Oracle promotes NDB as the perfect solution for high volume transactions in high availability. On the other hand, many famous users are reluctant in migrating applications to NDB. This session will help in understanding in practical terms when it makes sense to use NDB and when it is better to stay with or use InnoDB.
2:00pm-2:45pm (45m) Drizzle
Finally! How Drizzle Does the Things You've Always Wanted to Do
Monty Taylor (HP)
Drizzle has a rich plugin system, which means that Drizzle has a rather large set of available plugins which do things. Some of those plugins implement functionality that people have been asking for in the MySQL ecosystem for quite some time - such as LDAP or PAM based authentication, extremely flexible logging and direct use of Memcached. Come see how to actually do these things and more.
2:50pm-3:35pm (45m) Architecture and Technology, Data Warehousing and Business Intelligence, PHP and MySQL, Replication and Scale-Out
Summary Tables, Aggregate Tables and Materialized Views Using Flexviews
Justin Swanhart (Percona) et al
This talk describes using summary tables to improve application performance. It focuses on Flexviews, an open source toolkit based on MySQL stored procedures. Flexviews maintains summary tables and supports joins and aggregation. I'll show at a high level how Flexviews works and how it can be used to improve application performance. Examples will be provided for both OLTP and OLAP workloads.
10:50am-11:50am (1h) Architecture and Technology, Replication and Scale-Out
MySQL replication - all data everywhere, is it a good idea?
Sarah Novotny (NGINX)
MySQL's replication system has been a core feature often touted for scaling (sort of) and redundancy (sort of). I'll describe a client's extensive use of MySQL replication (they have more than 200 MySQL instances replicating to one another) as a reference for the many uses and misuses of replication.
11:55am-12:40pm (45m) Architecture and Technology, Storage Engine Development and Optimization
Metadata locking and deadlock detection in MySQL 5.5
Konstantin Osipov (MySQL)
MySQL 5.5 features a new transactional lock manager, available to all storage engines. The new subsystem allowed to solve a number of old MySQL architecture problems, such as lack of transactional awareness of data definition language, as well as opened the door for a number of new performance and scalability improvements.
2:00pm-2:45pm (45m) Architecture and Technology, PHP and MySQL
Engineering MySQL Subroutines for Integrity
Michael McLaughlin (BYU - Idaho)
Presents an in-depth view of how to combine and integrate MySQL subroutines with the security model. Shows how stored programs best support AJAX enabled web applications. Demonstrates how the MySQL security layers can support transaction control in stored functions and procedures. Provides examples on how to encapsulate key logic from web developers.
2:50pm-3:35pm (45m) Cloud Computing, Drizzle, Java, Replication and Scale-Out, Storage Engine Development and Optimization, Web 2.0, Ajax, and Emerging Technologies
High-Performance Storage Services Using HailDB and Java
Sunny Gleason (SunnyCloud)
This presentation introduces the St8 server, an open-source, REST-enabled storage service built using Jersey, Jetty, Guice, and most importantly, HailDB (formerly Embedded InnoDB). We describe interfacing HailDB with Java using JNA, and review benchmarks showing just how fast the service can be (including SSD as well as single-disk and RAID0 benchmarks).
10:50am-11:50am (1h) Replication and Scale-Out
Galera Replication
Seppo Jaakola (Codership) et al
Galera provides synchronous multi-master replication for MySQL/InnoDB. In a sense, it works like MySQL/Cluster but on top of InnoDB storage engine. Is this too good to be true?
11:55am-12:40pm (45m) Architecture and Technology, Replication and Scale-Out
A State of Multi-Master Replication
Seppo Jaakola (Codership) et al
Aside from traditional master-slave setup used mostly for HA and read scale-out, there is an established history of attempts at multi-master replication with MySQL. In this presentation we will look at what multi-master replication can do for us and compare different approaches of doing it.
2:00pm-2:45pm (45m) LAMP, NoSQL
Using Sphinx Beyond Full Text Search
Peter Zaitsev (Percona Inc) et al
Sphinx Search Engine is a well known tool for dealing with full text search problems on the large scale, but did you know you can use Sphinx for other tasks, which your traditional database may not be well suited for. This presentation will look into practical cases of using Sphinx beyond full text search and provide performance comparison to using MySQL for the same task.
2:50pm-3:35pm (45m) Migration, Replication and Scale-Out
Capacity Planning for High Volume Mysql Installations
Mark Konetchy (Facebook)
This talk will cover forecasting and planning future growth for high volume mysql instances occupying many (500+) servers. Will include metrics tracked (and how to filter through noise), when and how to migrate, operational optimizations such as upgrades that can be incorporated, and how to deal with server technology that evolves faster than server lifetimes
10:50am-11:50am (1h) Drizzle
BLOB Data And Thinking Out Side The Box
Barry Leslie (PrimeBase Technologies) et al
MySQL and Drizzle were never designed to handle BLOBs efficiently, storing BLOBs in the database results in huge memory requirements and bloated backups and replication logs. The PrimeBase BLOB management system (PBMS) is a daemon that is loaded by the database server and provides an efficient way of handling BLOBs that doesn’t have these problems.
11:55am-12:40pm (45m) Drizzle, Memcached, PHP and MySQL, Web 2.0, Ajax, and Emerging Technologies
Narada: using Gearman, Sphinx, Memcached, Drizzle and PHP to build a search application
Patrick Galbraith (Blue Gecko)
The Narada Search Application is a project that was an idea that was inspired while writing a book on how to take advantage of Sphinx, Gearman and MySQL that introduces a whole new way of thinking about web applications. Instead of a single monolithic web application, functionality is broken out into several Gearman workers to make for a much more scalable and dynamic application.
2:00pm-2:45pm (45m) Architecture and Technology, Performance Tuning and Benchmarking, Storage Engine Development and Optimization
Fulltext Searching with a Groonga Storage Engine
Tetsuro Ikeda (Sumisho Computer Sytems Corporation) et al
In this session, We introduce groonga Storage engine which enables for MySQL to handle fulltext search lightly. groonga is a library which have storages and indexes for fast fulltext searching. The backend of groonga Storage Engine is groonga library. With groonga Storage Engine, you can use datas in groonga as a usual MySQL tables.
2:50pm-3:35pm (45m) Migration, Security and Database Administration
Upgrading MySQL: Best Practices
Peter Zaitsev (Percona Inc)
Learn best practices in Upgrading MySQL from one Major version to another as well as tools helping to implement these best practices
10:50am-11:50am (1h) Architecture and Technology
Subqueries to the People: MariaDB Making the Impossible Possible and the Slow Fast
Timour Katchaounov (Monty Program Ab)
MySQL supports subqueries since version 4.1 released 8 years ago. Due to their simplistic implementation and resulting poor performance, subqueries have been considered as practically unusable by many users.
11:55am-12:40pm (45m) Drizzle
Performance Tuning for Drizzle
Monty Taylor (HP)
Now that you've decided to use Drizzle for everything, you're going to want to tune it to get the best out of your system. Some of the things you know from MySQL apply, some don't. Let's look at some real numbers and real graphs and see what Drizzle is doing.
2:00pm-2:45pm (45m) Drizzle
Fixed in Drizzle: No more "GOTCHA's"
Stewart Smith (Percona)
Drizzle has fixed many "gotcha" type things. Often we find ourselves saying "fixed in Drizzle". This is a whirlwind tour of what that is.
2:50pm-3:35pm (45m) Performance Tuning and Benchmarking, Replication and Scale-Out
Performance comparisons and trade-offs for various MySQL replication schemes
Darpan Dinker (Schooner Information Technology, Inc.) et al
Most MySQL deployments use some form of replication. Whether the reason is availability, scalability, backup, disaster recovery or archiving, understanding the performance characterization and trade-offs is critical to design and planning. If you have always wondered when and why to choose async/semi-sync/sync MySQL replication, DRBD or other interoperable technologies, this session is for you.
9:00am-9:30am (30m) Keynote
Building on Strengths, Learning from Differences
Baron Schwartz (VividCortex)
The last few years have brought technological and market shifts that have disrupted open-source databases. These include cloud computing, solid-state storage, non-SQL databases, and MySQL's acquisition. In this keynote presentation, Baron Schwartz will discuss the new reality that faces open-source database users and developers.
9:30am-10:00am (30m) Keynote
The Next Decade in Data Management
Mike Olson (Cloudera)
The meteoric growth of MySQL through the 1990s and 2000s were marked by some big in the enterprise database market -- a willingness to adopt open source software for critical business applications, and the emergence of a new class of database-backed web applications that needed a simpler, cheaper and more flexible storage model than the established vendors provided.
10:00am-10:20am (20m) Keynote
Best of Ignite
If you missed Ignite MySQLconf on Wednesday evening, come check out the Best of Ignite - several fun, high-energy “speed presentations” given by people like you.
3:50pm-4:35pm (45m) Keynote
Big and Small Data at @Twitter
Jeremy Cole (Twitter)
Keynote by Jeremy Cole, DBA Team Lead and MySQL Architect, Twitter.
10:20am-10:50am (30m)
Break: Morning Break
3:35pm-3:50pm (15m)
Break: Afternoon Break
4:35pm-5:15pm (40m)
Ice Cream Social Closing Reception
Join us in Exhibit Hall A immediately following the general sessions to celebrate four fantastic days of MySQL Conference & Expo. Take the opportunity to network one last time at this closing event, enjoy some ice cream and other tasty refreshments.
12:40pm-2:00pm (1h 20m)
Break: Lunch
  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Media Partners Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press & Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Bulletin

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts