O'Reilly MySQL Conference & Expo 2010 Schedule

Below are the confirmed and scheduled talks at O'Reilly MySQL Conference 2010 (schedule subject to change).

Customize Your Own Schedule

Create your own O'Reilly MySQL Conference schedule using the personal scheduler function. Mark the workshops, 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 High-throughput MySQL to your personal schedule
10:50am High-throughput MySQL Mark Callaghan (Facebook), Ryan Mack (Facebook), Ryan McElroy (Facebook)
Add Find Query Problems Proactively With Query Reviews to your personal schedule
2:00pm Find Query Problems Proactively With Query Reviews Sheeri K. Cabral (Mozilla Foundation)
Add Choosing Hardware and Operating Systems for MySQL to your personal schedule
2:50pm Choosing Hardware and Operating Systems for MySQL Peter Zaitsev (Percona Inc)
Ballroom B
Add Practical Distributed Processing Using MySQL Built-In Functionality to your personal schedule
10:50am Practical Distributed Processing Using MySQL Built-In Functionality Bob Burgess (Radian6 Technologies)
Add MySQL Graphing and Trending with Cacti to your personal schedule
11:55am MySQL Graphing and Trending with Cacti Baron Schwartz (VividCortex)
Add Cloud Vapour: a memcached Interface to NDB to your personal schedule
2:00pm Cloud Vapour: a memcached Interface to NDB Stewart Smith (Percona)
Add Demos Of All The Big New Features to your personal schedule
2:50pm Demos Of All The Big New Features Konstantin Osipov (MySQL), Peter Gulutzan (MySQL AB)
Ballroom C
Add InnoDB Plugin: Performance Features and Benchmarks to your personal schedule
10:50am InnoDB Plugin: Performance Features and Benchmarks Calvin Sun (Twitter), Jimmy Yang (Oracle Corporation), John Russell (Oracle Corporation)
Add New Query Engine Features in MariaDB to your personal schedule
11:55am New Query Engine Features in MariaDB Sergey Petrunya (Monty Program Ab)
Add MySQL Server Diagnostics Beyond Monitoring to your personal schedule
2:50pm MySQL Server Diagnostics Beyond Monitoring Gerardo Narvaja (SkySQL Inc.)
Ballroom D
Add Instrumenting your Application for MySQL and Memcached to your personal schedule
10:50am Instrumenting your Application for MySQL and Memcached Peter Zaitsev (Percona Inc)
Add XtraBackup: Hot Backups and More  to your personal schedule
11:55am XtraBackup: Hot Backups and More Vadim Tkachenko (Percona Inc), Morgan Tocker (Percona, Inc.)
Add 10x Performance Improvements - A Case Study to your personal schedule
2:00pm 10x Performance Improvements - A Case Study Ronald Bradford (EffectiveMySQL)
Add Recovery of Lost or Corrupted InnoDB Tables to your personal schedule
2:50pm Recovery of Lost or Corrupted InnoDB Tables Aleksandr Kuzminsky (Percona Inc)
Ballroom E
Add Achieving PCI Compliance with MySQL to your personal schedule
10:50am Achieving PCI Compliance with MySQL Ryan Lowe (Percona)
Add Continual Replication Sync to your personal schedule
11:55am Continual Replication Sync Danil Zburivsky (The Pythian Group)
Add SSD Deployment Strategies for MySQL to your personal schedule
2:00pm SSD Deployment Strategies for MySQL Yoshinori Matsunobu (DeNA)
Ballroom G
Add LIFTOFF  - MySQLCamp for Oracle DBA - Volume 2 to your personal schedule
10:50am LIFTOFF - MySQLCamp for Oracle DBA - Volume 2 Ronald Bradford (EffectiveMySQL)
Add MySQL Architecture Design Patterns for Performance, Scalability, and Availability to your personal schedule
11:55am MySQL Architecture Design Patterns for Performance, Scalability, and Availability Brian Miezejewski (MySQL), Alexander Rubin (MySQL)
Add Advanced Caching Strategies and Use Cases to your personal schedule
2:00pm Advanced Caching Strategies and Use Cases Frank Mashraqi (Opportunities)
Add Replication Tricks & Tips to your personal schedule
2:50pm Replication Tricks & Tips Mats Kindahl (Oracle), Lars Thalmann (Oracle)
Ballroom H
Add How TokuDB Fractal Tree Databases Work to your personal schedule
10:50am How TokuDB Fractal Tree Databases Work Bradley C. Kuszmaul (Tokutek)
Add Lucene, Solar and MySQL to your personal schedule
11:55am Lucene, Solar and MySQL Frank Mashraqi (Opportunities)
Add Introduction to Using MySQL in Cloud Computing to your personal schedule
2:00pm Introduction to Using MySQL in Cloud Computing Chuck Bell (Oracle), Mats Kindahl (Oracle)
Add Practical Partitioning With MySQL to your personal schedule
2:50pm Practical Partitioning With MySQL Brian Miezejewski (MySQL)
Ballroom F
Add Scaling MySQL in the Cloud to your personal schedule
10:50am Scaling MySQL in the Cloud Moshe Shadmon (ScaleDB)
Add How to Choose High Availability Solutions for MySQL to your personal schedule
11:55am How to Choose High Availability Solutions for MySQL Peter Zaitsev (Percona Inc)
Add Monitoring memcached to your personal schedule
2:50pm Monitoring memcached Alan Kasindorf (Six Apart)
12:40pm Lunch
Room: Pool Area & Santa Clara Ballroom
Bayshore
Add State of the MySQL Community to your personal schedule
8:30am Plenary
Room: Ballroom EFGH
State of the MySQL Community Kaj Arnö (SkySQL Ab)
Add The Engines Of Community to your personal schedule
9:15am Plenary
Room: Ballroom EFGH
The Engines Of Community Jono Bacon (Canonical Ltd)
Add Best of Ignite MySQL to your personal schedule
10:00am Plenary
Room: Ballroom EFGH
Best of Ignite MySQL
Add RethinkDB: Why Start a New Database Company in 2010 to your personal schedule
3:50pm Closing Keynote
Room: Ballroom EFGH
RethinkDB: Why Start a New Database Company in 2010 Slava Akhmechet (RethinkDB), Michael Glukhovsky (RethinkDB)
10:20am Morning Break
Room: Ballroom Foyer
3:35pm 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
10:50am-11:50am (1h) Replication and Scale-Out, Storage Engine Development and Optimization
High-throughput MySQL
Mark Callaghan (Facebook) et al
Facebook runs MySQL on commodity servers. Commodity servers have become extremely fast. Learn about the methods we use to identify performance bottlenecks in MySQL and the projects we have completed or started to keep pace with hardware advances.
11:55am-12:40pm (45m) Architecture and Technology
Worst Practices of Outsourcing Database Infrastructure Support
Paul Vallee (Pythian)
This presentation outlines the typical and costly mistakes organizations make when outsourcing their database infrastructure support - a recipe for disaster that guarantees the failure of these initiatives. Learn how to avoid these mistakes by using our best practices for setting the right expectations, establishing proper working communication channels, partnering with your vendor, and more.
2:00pm-2:45pm (45m) Performance Tuning and Benchmarking
Find Query Problems Proactively With Query Reviews
Sheeri K. Cabral (Mozilla Foundation)
Query reviews are a great way to find potentially slow queries before they become a problem. A query review is like a code review, except instead of reviewing code, queries are reviewed. This presentation will show you how to use the Maatkit tool mk-query-digest to create a digest of queries. This digest can be a one-off report, or it can be saved to a database table.
2:50pm-3:35pm (45m) LAMP, Performance Tuning and Benchmarking, Storage Engine Development and Optimization
Choosing Hardware and Operating Systems for MySQL
Peter Zaitsev (Percona Inc)
Wondering how to build a good foundation for running MySQL? This session will teach you what you need to know.
10:50am-11:50am (1h) Architecture and Technology, Business and Case Studies, Replication and Scale-Out
Practical Distributed Processing Using MySQL Built-In Functionality
Bob Burgess (Radian6 Technologies)
Distributed processing doesn't always require learning completely new methods. See how we solved an intense computation problem which was over-taxing our main database by distributing it across multiple machines, using only MySQL built-in functionality. No Map/Reduce. No external frameworks. It's simple -- and it works well, too!
11:55am-12:40pm (45m) Architecture and Technology, General, LAMP, Performance Tuning and Benchmarking
MySQL Graphing and Trending with Cacti
Baron Schwartz (VividCortex)
This session shows you how to get rich historical data about your MySQL server's performance and usage with the open-source Cacti graphing tool. Best of all, it's easy, open-source, and free -- so you can stop flying blind.
2:00pm-2:45pm (45m) Cloud Computing, MySQL Cluster and High Availability
Cloud Vapour: a memcached Interface to NDB
Stewart Smith (Percona)
Vapour is a server that speaks the memcached protocol and uses MySQL Cluster (NDB) as the storage backend.
2:50pm-3:35pm (45m) Architecture and Technology
Demos Of All The Big New Features
Konstantin Osipov (MySQL) et al
A demo of downloadable publicly available as-of-April-2010 MySQL alphas + betas.
10:50am-11:50am (1h) Performance Tuning and Benchmarking
InnoDB Plugin: Performance Features and Benchmarks
Calvin Sun (Twitter) et al
There are many exciting performance features in the InnoDB Plugin. But how to best use them? What are the caveats? At this session, we will describe those performance features in depth. We will also present benchmark results that explore the performance of those features.
11:55am-12:40pm (45m) Architecture and Technology
New Query Engine Features in MariaDB
Sergey Petrunya (Monty Program Ab)
MariaDB is a branch of MySQL with additional and improved features. This talk is about MariaDB's unique query engine features: Table Elimination,Batched Key Access, and a set of Subquery Optimizations (development of the latter two was started at MySQL but MariaDB has fixed and improved variants). Each of the features will be explained in easy manner and also a benchmark will be shown.
2:00pm-2:45pm (45m) Architecture and Technology, Cloud Computing, Data Warehousing and Business Intelligence, Replication and Scale-Out
Gearman MySQL Hacks, or Everything You Wanted to Do With a Database Server and You Never Dared to Hope
Giuseppe Maxia (Continuent) et al
Users of Gearman know that it is a distributed client/server system that allows great flexibility to developers and DBAs. Advanced users of this tool have come up with amazing examples of cunning hacks that will possibly help you in your daily tasks immediately or get you started in your path of creating your own hacks.
2:50pm-3:35pm (45m) Performance Tuning and Benchmarking, Replication and Scale-Out, Security and Database Administration
MySQL Server Diagnostics Beyond Monitoring
Gerardo Narvaja (SkySQL Inc.)
Discuss what to look at when regular monitoring information is not descriptive enough. Review how to obtain useful status snapshots and how to interpret the results using real world examples covering items like: replication health, memory allocation, network issues and performance.
10:50am-11:50am (1h) LAMP, Performance Tuning and Benchmarking, PHP and MySQL
Instrumenting your Application for MySQL and Memcached
Peter Zaitsev (Percona Inc)
The best way to understand your application's performance is to have good performance instrumentation in your application. This session will teach you how and where to instrument your application, and how to analyze the results.
11:55am-12:40pm (45m) Security and Database Administration
XtraBackup: Hot Backups and More
Vadim Tkachenko (Percona Inc) et al
This session is an overview of XtraBackup, a free, open-source hot backup solution for InnoDB and XtraDB engines.
2:00pm-2:45pm (45m) Architecture and Technology, General, Performance Tuning and Benchmarking
10x Performance Improvements - A Case Study
Ronald Bradford (EffectiveMySQL)
Taking a client from a minimum 700ms, and at times 1-2 seconds front page load time to a consistent 60ms is a great success story for the improvements possible in optimizing database performance. In this presentation we will outline the steps taken and what can be applied to any website as one possible model to use in evaluation of your website, as well as provide specific examples.
2:50pm-3:35pm (45m) Architecture and Technology, Security and Database Administration, Tutorial
Recovery of Lost or Corrupted InnoDB Tables
Aleksandr Kuzminsky (Percona Inc)
It is still possible to bring back corrupted or unintentionally deleted InnoDB tables as long as data remain on medium. During the session various recovery scenarios will be scrutinized. The typical cases will be illustrated using InnoDB Recovery Tool.
10:50am-11:50am (1h) Security and Database Administration
Achieving PCI Compliance with MySQL
Ryan Lowe (Percona)
Achieving PCI compliance can be a difficult and expensive process. This session will begin by clarifying which requirements affect MySQL and then step through each requirement, providing common solutions to satisfy them.
11:55am-12:40pm (45m) Replication and Scale-Out
Continual Replication Sync
Danil Zburivsky (The Pythian Group)
Are you ensuring that a slave has the same data is the same as its master? Using mk-table-checksum from Ma'atkit as the basic tool, we will show you how to check that your data is in sync -- in a non-invasive way. We will share the tricks, tips and gotchas we have learned deploying this method in several different environments and schemas.
2:00pm-2:45pm (45m) Architecture and Technology, Performance Tuning and Benchmarking
SSD Deployment Strategies for MySQL
Yoshinori Matsunobu (DeNA)
This session is about SSD deployment strategies for MySQL. For example, is it fine to store all files on SSD or is it faster to store some files (i.e. binary log files) on HDD? Is RAID 5 SSD fast enough? Do traditional H/W raid cards perform well for many(4-8) SSDs? Do MyISAM/InnoDB/other engines work well for SSD? I'll talk about these topics based on many kinds of recent benchmarking results.
2:50pm-3:35pm (45m) Ruby and MySQL
Beyond 'gem install MySQL' in Ruby VMs: Alternative Drivers & Architecture
Ilya Grigorik (igvita.com)
There is much more to MySQL performance in Ruby than 'gem install mysql' and syntactic optimizations. Whether you are running Ruby MRI (C version), or JRuby (JVM), or any other Ruby VM, and are looking to optimize your performance architecture (response times or throughput), the architecture and the MySQL driver you choose have significant influence on the outcome.
10:50am-11:50am (1h) Architecture and Technology, Migration
LIFTOFF - MySQLCamp for Oracle DBA - Volume 2
Ronald Bradford (EffectiveMySQL)
RDBMS administration and management are built on common database practices. What is needed is a clear translation across varying technologies. An instruction manual to cross reference the common pieces with the differing pieces and highlighting the subtle but more important differences in the technologies. This is for the Oracle DBA to understand, appreciate and manage MySQL successfully.
11:55am-12:40pm (45m) Architecture and Technology
MySQL Architecture Design Patterns for Performance, Scalability, and Availability
Brian Miezejewski (MySQL) et al
MySQL consultants have collected a toolset of MySQL architecture design patterns that are proven solutions for most MySQL system requirements. Each pattern has different strengths or weaknesses based on the application it may be used with. Learn the common patterns and which will work best for your applications and requirements.
2:00pm-2:45pm (45m) Architecture and Technology, Replication and Scale-Out
Advanced Caching Strategies and Use Cases
Frank Mashraqi (Opportunities)
Caching is a powerful weapon in the arsenal of an enterprise data architect. Designing an optimal caching strategy for your organization can increase performance and help save cost, but a poorly designed caching strategy often hurts more than it helps. We will cover strategies encompassing popular options available for caching.
2:50pm-3:35pm (45m) General
Replication Tricks & Tips
Mats Kindahl (Oracle) et al
Replication is a versatile tool to use in your toolbox. It can be used to solve many problems modern web architectures, as well as various ways to simplify maintenance.
10:50am-11:50am (1h) Architecture and Technology, Storage Engine Development and Optimization
How TokuDB Fractal Tree Databases Work
Bradley C. Kuszmaul (Tokutek)
This talk explains how TokuDB Fractal Trees work and presents both theoretical and empirical evidence of its performance advantages.
11:55am-12:40pm (45m) Architecture and Technology, Web 2.0, Ajax, and Emerging Technologies
Lucene, Solar and MySQL
Frank Mashraqi (Opportunities)
Lucene is a powerful, high-performance, full-featured text search engine library. In this presentation, learn how you can use Lucene with MySQL to offer powerful searching capabilities to your stakeholders. This session is highly recommended for those looking to add full-text cross-platform, database independent search capability to their application.
2:00pm-2:45pm (45m) Architecture and Technology, Cloud Computing
Introduction to Using MySQL in Cloud Computing
Chuck Bell (Oracle) et al
Have you outgrown your data infrastructure or need to leverage more powerful computing hardware but don't have the budget to build your own information technology solutions? If you find yourself wondering how you can afford more powerful database systems but only need them for a limited timeframe, this session will give you the information you need to access and use MySQL in a cloud environment.
2:50pm-3:35pm (45m) Architecture and Technology
Practical Partitioning With MySQL
Brian Miezejewski (MySQL)
There are many examples and posts on how to use partitioning in MySQL, but little information on when to use it and how to apply it to typical business problems. This talk focusses on when to use partitioning, what type to use, and what are the best practices in using the different types of MySQL partitioning.
10:50am-11:50am (1h) Architecture and Technology, Cloud Computing, Data Warehousing and Business Intelligence, Storage Engine Development and Optimization
Scaling MySQL in the Cloud
Moshe Shadmon (ScaleDB)
ScaleDB transforms dynamically and transparently an open source MySQL deployment to a clustered "cloud ready" DBMS deployment. This is done by ScaleDB’s clustered storage engine that provides "out of the box" scalability and availability.
11:55am-12:40pm (45m) MySQL Cluster and High Availability
How to Choose High Availability Solutions for MySQL
Peter Zaitsev (Percona Inc)
When it is time to choose a High-Availability solution for MySQL, the number of solutions can lead to confusion. This session will help you make sense of replication, Cluster, DRBD and more.
2:00pm-2:45pm (45m) Architecture and Technology, Performance Tuning and Benchmarking
How to Fulfil the Potential of InnoDB's Performance and Scalability
Yasufumi Kinoshita (Percona Inc.)
This session describes how to tune InnoDB based mainly on 'SHOW ENGINE INNODB STATUS' outputs. The current version of InnoDB Plugin and XtraDB have various tunable options. It will be cleared how the tuning options improves the performance for what condition. The improvement is also demonstrated by the results of some benchmark workloads.
2:50pm-3:35pm (45m) Architecture and Technology, Performance Tuning and Benchmarking
Monitoring memcached
Alan Kasindorf (Six Apart)
Monitoring usage, efficiency, and performance of memcached can seem like a dark art. For most people, configuring a RAM limit and shoving in data is as far as they need to go. If you need to know more about how efficiently you are using memcached, as well as how all the statistics line up to make a big picture, this is the place.
12:40pm-2:00pm (1h 20m)
Break: Lunch
8:00am-3:00pm (7h)
Open Space for MySQL Participants
Open Space for MySQL Participants 2010, a community organized event designed to share and improve the essential skills required to participate in collaborative, free and open online projects. The event features a mix of educational presentations and hands-on coaching from experts in participatory communities. MySQL Open Space attendance is free with an Expo Hall pass.
8:30am-9:15am (45m) Keynote
State of the MySQL Community
Kaj Arnö (SkySQL Ab)
In a complement to Edward Screven's opening keynote, Kaj will interpret the state of the MySQL community and the happenings of the MySQL Conference in a language familiar to those whose business has grown up with MySQL. What has changed already, what will change soon, and what won't change with Oracle as the steward of MySQL?
9:15am-10:00am (45m) Keynote
The Engines Of Community
Jono Bacon (Canonical Ltd)
In this brand new talk, Jono Bacon, Ubuntu Community Manger, author of the critically acclaimed The Art Of Community by O'Reilly and founder of the annual Community Leadership Summit, talks about the evolution of community and how we can identify the engines of community, helping us to unite a global collection of volunteers to solve interesting and worthwhile problems.
10:00am-10:20am (20m)
Best of Ignite MySQL
Join us as we present the best of Wednesday night's Ignite MySQL presentations.
3:50pm-4:35pm (45m) Keynote
RethinkDB: Why Start a New Database Company in 2010
Slava Akhmechet (RethinkDB) et al
Why start a new database company? What is RethinkDB all about? What will database technology look like twenty years from now? In this talk we will explore these questions, present some of the exciting technology we've been developing at RethinkDB, and show how it fits into our larger vision of what database systems may look like in the future
10:20am-10:50am (30m)
Break: Morning Break
3:35pm-3:50pm (15m)
Break: Break
4:35pm-5:15pm (40m)
Ice Cream Social Closing Reception
Take the opportunity to network one last time at this closing event, enjoy ice cream and refreshments. Say thank you and exchange contact information until next year.
  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

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

Download the O'Reilly MySQL Conference & Expo Sponsor/ Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

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

O'Reilly MySQL Conference Newsletter

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

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.