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]](/images/personal-schedule-icon.png){kind=icon}
next to each listing. Then click on "personal schedule" below and get your own customized schedule generated.
Topics
- Architecture and Technology
- Business and Case Studies
- Cloud Computing
- Data Warehousing and Business Intelligence
- General
- Java
- Keynote
- LAMP
- Migration
- MySQL Cluster and High Availability
- Performance Tuning and Benchmarking
- Products and Services
- Replication and Scale-Out
- Ruby and MySQL
- Security and Database Administration
- Storage Engine Development and Optimization
- Web 2.0, Ajax, and Emerging Technologies
Ballroom A
Ballroom C
Ballroom B
Scalability and Reliability Features of MySQL Connector/J Mark Matthews (Oracle), Todd Farmer (Oracle Corporation)
Linux Performance Tuning and Stabilization Tips Yoshinori Matsunobu (DeNA)
Ballroom D
Ballroom E
What's new in MySQL Globalization/Internationalization Alexander Barkov (Sun)
Ballroom H
InnoDB: Status, Architecture, and New Features Rob Young (Oracle/MySQL ), Calvin Sun (Twitter)
5:15pm
TBC
Ballroom F
Ballroom G
12:40pm
Lunch
Room: Pool Area & Santa Clara Ballroom
Room: Pool Area & Santa Clara Ballroom
Bayshore
10:20am
Morning Break
Room: Exhibit Hall A
Room: Exhibit Hall A
3:50pm
Afternoon Break: Located in Expo Hall
Room: Exhibit Hall A
Room: Exhibit Hall A
Expo Hall
10:50am-11:50am (1h)
LAMP, Web 2.0, Ajax, and Emerging Technologies
Using Drizzle
Eric Day (craigslist), Monty Taylor (HP)
Drizzle is a fork of the MySQL server focused on modularity, improved performance, and community development. This session will give an overview of the current state of Drizzle, how to install it, and the state of the current tools and language APIs available. The session will also show how to get started with management, writing simple applications, and porting existing applications.
11:55am-12:40pm (45m)
General, Performance Tuning and Benchmarking
Monitoring Drizzle or MySQL With DTrace and SystemTap
Padraig O'Sullivan (Akiban Technologies Inc.)
Drizzle and MySQL both have a number of static DTrace probes embedded
within them which allows observability tools to gain deep insight into
what the server is doing. In this session, an overview of these static
probes will be given and examples of utilizing these probes will be
shown using both DTrace on Solaris and SystemTap on Linux.
2:00pm-3:00pm (1h)
Architecture and Technology, General, Replication and Scale-Out
New Replication Features
Mats Kindahl (Oracle), Lars Thalmann (Oracle)
In this talk, the developers behind MySQL Replication walk through some of the new Replication features of MySQL 5.5
3:05pm-3:50pm (45m)
Architecture and Technology, LAMP, Web 2.0, Ajax, and Emerging Technologies
Connecting MySQL and Python
Geert Vanderkelen (Sun Microsystems)
This talk will give an overview of how to connect to MySQL and which
drivers are available today under Python v2.x, and tomorrow's Python v3.x.
We'll dive into MySQLdb, its strong history, its present. We'll go over
OurSQL and various other community projects, as well as Sun Microsystems'
MySQL Connector/Python (mainted by the speaker).
4:25pm-5:10pm (45m)
General, Security and Database Administration
Better Database Debugging for Shorter Downtimes
Robert Hamel (Pythian)
Learn how to find your database problems more quickly without special software. Automatically tracking all database changes and keeping a historical record enables you to figure out problems faster, reducing downtime for critical production systems. Existing monitoring systems are very good at detecting actual errors but not very good at telling you what triggered your performance issue
5:15pm-6:00pm (45m)
Architecture and Technology
MySQL Plugin API: New Features
Sergei Golubchik (MariaDB)
After a short introduction this talk will describe new features in the plugin API - new plugin types, with use cases and examples, and Server Services - the solution to the main problem that prevents a true binary plugin independence.
10:50am-11:50am (1h)
Architecture and Technology, Data Warehousing and Business Intelligence, Performance Tuning and Benchmarking, Replication and Scale-Out, Security and Database Administration, Web 2.0, Ajax, and Emerging Technologies
What's New in MySQL 5.5? Performance/Scale Unleashed!
Rob Young (Oracle/MySQL ), Mikael Ronstrom (MySQL)
Join the MySQL and InnoDB Engineering teams as they describe the
low-level technical details behind the MySQL 5.5 performance and
scalability gains.
11:55am-12:40pm (45m)
Products and Services
What's New in MySQL 5.5?: Performance and Scalability Benchmarks
Mikael Ronstrom (MySQL)
Join the MySQL and InnoDB Engineering teams to examine the eye popping
MySQL 5.5 performance and scalability benchmarks.
2:00pm-3:00pm (1h)
General, Performance Tuning and Benchmarking, Security and Database Administration
EXPLAIN Demystified
Baron Schwartz (VividCortex)
MySQL's EXPLAIN output is rich with information, but can be difficult to understand. This session helps EXPLAIN make sense by showing how it reveals the server's estimated query execution plan.
3:05pm-3:50pm (45m)
Architecture and Technology, Cloud Computing, Replication and Scale-Out
Getting Started With Gearman For MySQL
Giuseppe Maxia (Continuent), Eric Day (craigslist)
Gearman is a distributed client/server architecture that can handle tasks independently from programming language and operating systems. Using it, you can create flexible and efficient applications. Through MySQL UDFs, Gearman functions can me made available to a MySQL server directly.
4:25pm-5:10pm (45m)
Architecture and Technology, Business and Case Studies, General, Performance Tuning and Benchmarking
Optimizing MySQL Stored Routines
Roland Bouman (XCDSQL Solutions / Strukton Rail)
Many casually written stored routines are unnecessarily slow. By observing a few principles, you can gain substantive benefits for performance and maintainability of your stored routines. By applying step-wise improvements to real-world examples you will become aware of potential problems in your own stored routines and learn how to refactor them to increase performance and maintainability.
5:15pm-6:00pm (45m)
Replication and Scale-Out
MySQL Proxy Meets: Memcache
Jan Kneschke (MySQL)
Memcache is one of the tools of scaling read heavy architectures, but keeping it in sync with MySQL can be a challenge: scalability vs. consistency ? Do it in the app or the database ? Storage engines or Triggers + UDF ? Let's rethink it and make it scalable and consistent: let's replicate from MySQL to memcache.
10:50am-11:50am (1h)
Replication and Scale-Out
High Concurrency MySQL
Domas Mituzas (Facebook)
War and peace stories from Facebook - how to detect, analyze and fix problems below, inside and above overloaded MySQL servers.
This covers concurrecy problems that appear in real world environments, beyond labs and benchmarks.
11:55am-12:40pm (45m)
General, MySQL Cluster and High Availability
MySQL Cluster: An Introduction
Geert Vanderkelen (Sun Microsystems)
Lets unleash MySQL Cluster information on people by starting with the
very basics!
This talk will give you an idea on what great tool MySQL Cluster and how it can help you reach high availability.
We'll show you how it works without going to much in the technical
details. Showing off where it make sense to deploy, and stress points
where you should not use Cluster (yet).
2:00pm-3:00pm (1h)
Migration
Migration From Oracle to MySQL : An NPR Case Study
Joanne Garlow (National Public Radio)
Speed up your own migration from Oracle to MySQL by learning from NPR.org’s success. See how MySQL might allow you to improve your database architecture. Learn some specific differences in SQL to be aware of between Oracle and MySQL. A few free tools we found helpful will be demoed. Finally some test cases we found revealed the trickiest issues will be discussed.
3:05pm-3:50pm (45m)
Performance Tuning and Benchmarking, Security and Database Administration
Introduction to InnoDB Monitoring System and Resource & Performance Tuning
Jimmy Yang (Oracle Corporation)
At this session, we will talk about current interfaces of the InnoDB monitoring system, including server status variables, information schema table, as well as table and space monitor. We will also discuss how to utilize these information to better understand the system running state.
4:25pm-5:10pm (45m)
General, Java, Performance Tuning and Benchmarking, Replication and Scale-Out
Scalability and Reliability Features of MySQL Connector/J
Mark Matthews (Oracle), Todd Farmer (Oracle Corporation)
Learn about the features built into MySQL Connector/J targeted at scalability and reliability. The session will cover fault tolerant load balancing, replication-aware load balancing with slave fail-over, custom exception handling and some creative use of statement interceptors mixed with the built-in load balancer to implement sharding.
5:15pm-6:00pm (45m)
LAMP, Performance Tuning and Benchmarking
Linux Performance Tuning and Stabilization Tips
Yoshinori Matsunobu (DeNA)
Many people know Linux terminologies such as ext3, tmpfs, cfq io scheduler, OOM killer, etc. But many times it is not appropriately configured. In this session, the speaker will show Linux performance tuning and stabilization practices for MySQL, such as how to avoid OOM Killer, performance difference between I/O schedulers, tuning Linux kernel parameters, profiling with SystemTap, etc.
10:50am-11:50am (1h)
Architecture and Technology, Cloud Computing
MySQL in the Cloud - Endless Possibilities
Grant McAlister (Amazon.com)
In this session we will show how the cloud capabilities that many vendors are now offering make it possible for a single developer to build solutions that even large companies find difficult or impossible to do.
11:55am-12:40pm (45m)
General, MySQL Cluster and High Availability, Replication and Scale-Out, Storage Engine Development and Optimization, Web 2.0, Ajax, and Emerging Technologies
Sharding for the Masses
Giuseppe Maxia (Continuent), Kentoku SHIBA (WildGrowth)
Sharding is a hot topic. Every big web site is using some sharding
technique with home made solutions. The quest for the silver bullet goes on
without apparent good results. This session will present two MySQL storage
engines (Spider and Vertical partitioning) that implement transparent
sharding techniques.
2:00pm-3:00pm (1h)
Architecture and Technology, General, Replication and Scale-Out
What is memcached and What Does It Do?
Brian Moon (dealnews.com)
Memcached has become the de facto standard for caching web applications. But, many users jump in feet first without understanding what it does or perhaps more importantly what it does not do. Once you understand memcached, you may come to realize that it is what it does not do that makes it so good.
3:05pm-3:50pm (45m)
Migration
Can I Migrate My Database to MySQL and What Will It Cost?
Brian Miezejewski (MySQL)
This talk outlines the process used by MySQL’s database migration experts in determining the feasibility and effort of migrating from database X to MySQL. We will cover the primary inputs, metrics, deliverables and process used to assess the effort and cost of migrating to MySQL.
4:25pm-5:10pm (45m)
Architecture and Technology, LAMP, Replication and Scale-Out, Security and Database Administration
Clustering for the Masses - A Gentle Introduction to Tungsten for MySQL
Robert Hodges (Continuent.com)
Production MySQL deployments face constant challenges to keep databases up, avoid data loss, and scale performance. Tungsten offers a unique open source implementation of master/slave clustering that integrates replication, management, and SQL routing. We will present a tutorial introduction that shows how to set up and use Tungsten at home. Come see what the excitement is about!
5:15pm-6:00pm (45m)
Architecture and Technology, Replication and Scale-Out, Security and Database Administration
Running Multiple MySQL Instances On a Single Server
Ben Black (Garmin), Mark Filipi (Garmin International)
Running multiple MySQL instances on the same hardware can be useful in a number of cases.
Some uses are rapid creation of test instances, consolidating several instances, mixing masters and slaves for redundancy and to balance load, and better hardware utilization. We will cover aspects including load balancing, LVM, repeatable builds, ports, proxy, and problems we encountered along the way.
10:50am-11:50am (1h)
MySQL Cluster and High Availability
Discover What's New in MySQL Cluster 7.1
Bernhard Ocklin (Sun Microsystems AB), Andrew Morgan (Oracle)
In blazing speed we will cover the most important features of MySQL Cluster 7.1: NDB$INFO; MySQL Cluster Connector/Java and a bunch of other features that push the limits of MySQL Cluster into new workloads and communities
11:55am-12:40pm (45m)
Cloud Computing, Data Warehousing and Business Intelligence, Java, Web 2.0, Ajax, and Emerging Technologies
Parallel MySQL Import and Export to Hadoop
Aaron Kimball (Cloudera, Inc.)
This talk introduces Sqoop, the open source SQL-to-Hadoop tool. Sqoop helps users perform efficient imports of data from MySQL and other databases to Hadoop's distributed file system, where it can be processed in concert with other data sources. Sqoop also allows users to export Hadoop-generated results back to MySQL and other systems for use with other data pipelines.
2:00pm-3:00pm (1h)
Architecture and Technology, Storage Engine Development and Optimization
A Practical Guide to the PBXT Storage Engine
Paul McCullagh (PrimeBase Technologies GmbH)
With the GA version of PBXT soon to be released, this presentation will tell you how to get the most out of the storage engine. All information is relevant to developers, DBAs and anyone interested in getting started with PBXT.
3:05pm-3:50pm (45m)
Ruby and MySQL
High Performance Ruby on Rails and MySQL
David Berube (Berube Consulting)
Database access in Ruby on Rails can be extremely slow, but it doesn't have to be: this talk will discuss ways you can get massive performance speedups by increasing your query efficiency and by minimizing ActiveRecord object creation. This can keep your application scalable and responsible even under large datasets and modest hardware.
4:25pm-5:10pm (45m)
Performance Tuning and Benchmarking
An Overview of Flash Storage for Databases
Vadim Tkachenko (Percona Inc), Morgan Tocker (Percona, Inc.)
Flash storage has gone from an experimental buzzword to a major new storage technology so fast that it is hard to understand what is on the market. This is a comprehensive comparison of what's available today.
5:15pm-6:00pm (45m)
Architecture and Technology
What's new in MySQL Globalization/Internationalization
Alexander Barkov (Sun)
This session is a must for all DBAs and users
who store data in various word languages in MySQL database,
including European languages, Japanese, Chinese, Korean,
as well as for those using MySQL in a multi-lingual environment.
All SQL standard fans are also welcome to know what's happening
in MySQL for better conformance in how MySQL handles identifiers, character sets, collations.
10:50am-11:50am (1h)
Products and Services
Mastering MySQL Design and Development using MySQL Workbench 5.2
Michael G. Zinner (Sun Microsystems)
For many developers and DBAs, MySQL Workbench is their preferred graphical interface into the MySQL database. Come learn from the pros and master the essential Workbench techniques for designing and developing MySQL databases and applications. In this session Mike and Alfredo will show you how to streamline your work to rapidly go from idea to a production MySQL application.
11:55am-12:40pm (45m)
Products and Services
Agile BI – Collapsing BI from Months to Minutes
Richard Daley (Pentaho Corporation)
Einstein was wrong, you can make time stand still (or at least make it appear to when building your next BI application). Traditional business intelligence technologies have limited the development of BI applications to the classic waterfall model. With the release of Pentaho Data Integration / Kettle 4.0, the first integrated ETL, data modeling and visualization development environment...
2:00pm-3:00pm (1h)
Products and Services
Let’s Talk About Linux and Virtualization in “vLAMP”!
Wim Coekaerts (Oracle), Greg Marsden (Oracle)
Join Oracle’s Linux and Virtualization guru, Wim Coekaerts, as he discusses Oracle’s Linux roadmap, and details specific features and contributions that will continue to drive Linux as a leading operating system for MySQL users. Wim will also talk about the role of virtualization, specifically Oracle VM, for MySQL and Linux deployments.
3:05pm-3:50pm (45m)
Architecture and Technology
InnoDB: Status, Architecture, and New Features
Rob Young (Oracle/MySQL ), Calvin Sun (Twitter)
InnoDB is the most popular, reliable and functional of the transactional storage engines available for MySQL. At this session, you will learn the current state of InnoDB and the new features in the InnoDB Plugin. You will also learn how InnoDB works and why those new features improve the performance and scalability.
4:25pm-5:10pm (45m)
Products and Services
Add Reporting and Analytics to MySQL in 10 minutes
Rushabh Mehta (SolidQ)
Do you need a straightforward way to add reporting to your MySQL applications? Enable end-users to build their own reports? Provide analytic capabilities that let your users leverage Excel to evaluate MySQL data combined with other managed and unmanaged data sources? This is the session for you.
5:15pm-6:00pm (45m)
Session
To be confirmed
10:50am-11:50am (1h)
Business and Case Studies
MariaDB: What? Who? How? Why? Where?
Kurt von Finck (Monty Program Ab)
This session will introduce you to MariaDB, the drop-in replacement for MySQL produced by Monty Program. Monty Program was founded by Michael "Monty" Widenius, the original author of MySQL, and employs some of the best developers in the MySQL ecosystem. Come see what this important derivative can do for you, and what you can contribute back!
11:55am-12:40pm (45m)
Architecture and Technology, Performance Tuning and Benchmarking
Performance Schema
Peter Gulutzan (MySQL AB)
Performance Schema is a major new MySQL Server feature which shows where we're going with monitoring and performance measurement.
2:00pm-3:00pm (1h)
Cloud Computing
Nokia’s Performance Enhancements to Voldemort Key-Value Cloud Database with MySQL High Performance Persistent Store
Alex Esterkin (Open Source Community)
Project Voldemort is an open source eventually consistent cloud key-value database with pluggable persistent store architecture. This session focuses on Nokia’s contributions to Voldemort and covers various aspects of MySQL schema optimization; connection pooling and concurrency tweaks in the MySQL Connector/J based client; and MySQL/InnoDB performance tuning.
3:05pm-3:50pm (45m)
Data Warehousing and Business Intelligence
Pentaho Data Integration 4.0 and MySQL
Matt Casters (Pentaho)
This presentation provides an overview of Pentaho Data Integration (a.k.a. Kettle) with a focus on how it can help you to work with MySQL databases.
4:25pm-5:10pm (45m)
Performance Tuning and Benchmarking
The Five Minute DBA
Matt Yonkovit (Percona)
A lot of companies do not have a dedicated DBA, rather they rely on sysadmins, web developers, or others to put the DBA hat on five minutes at a time. This session is designed to provide these people the basic DBA tips and tricks they need to be successful. What are the most important parameters? What sort of hardware should the database run on? When I have a problem where do I look?
5:15pm-6:00pm (45m)
Architecture and Technology
OQGRAPH engine: hierarchies/graphs inside the database made easy
Arjen Lentz (Open Query), Antony Curtis (Blizzard Entertainment)
The OQGRAPH (GPLv2+) engine allows you to deal with hierarchies (such as category trees) and graphs (such as social networks) right inside your database. It works together with other storage engines (such as InnoDB) using normal joins. there are no SQL syntax additions or changes.
10:50am-11:50am (1h)
Products and Services
New Trends and Performance Trade-offs in Database Acceleration for Data Warehouse Workloads
Joseph Chamdani, Ph.D. (Kickfire)
In this session, recent query acceleration trends in data warehouse workloads including column stores, disk filtering, hardware acceleration, SSD, MPP and SQL coprocessors will be compared. We’ll describe in detail Kickfire’s dataflow hardware acceleration and provide real-world examples from our enterprise customers.
11:55am-12:40pm (45m)
Products and Services
Performance and Feature Enhancements to MySQL and InnoDB
Bill Schuler (Percona, Inc.), Baron Schwartz (VividCortex)
Have you heard the buzz about Percona's enhancements to MySQL? What
about XtraDB, Percona's high-performance storage engine based on InnoDB?
Come learn what all the fuss is about. In this session you'll learn
about these and other open-source projects, and you'll get a preview of
the exciting roadmap for their future.
2:00pm-3:00pm (1h)
Products and Services
Blazing Queries: Achieving High Performance Analytics With Infobright
David Lutz (Infobright)
Learn how Infobright's columnar analytic database delivers very fast query response against large volumes of data without indexes, data partitioning or other DBA effort. Includes case studies on the leading mobile analytics company who saw query response time reduced from many minutes to just seconds and a large energy company who had data compression of 98% and implemented a data mart in weeks.
3:05pm-3:50pm (45m)
Products and Services
Valuable MariaDB Features That Somebody Paid For
Henrik Ingo (MongoDB), Igor Babaev (Monty Program)
The benefit of using an open source database is that for your critical
needs, you have the possibility of adding the feature you really want. In this talk we'll present some MariaDB features that were created for a paying customer to solve their specific need. These go from feature enhancements to the mysqlbinlog tool to performance optimizations for certain joins and MyISAM keycache.
4:25pm-5:10pm (45m)
Delivering Reporting and Data Analysis With MySQL and Jaspersoft
Sherman Wood (JasperSoft)
Reporting and data analysis, or "business intelligence", is a part of many MySQL environments. This session will show how to implement business intelligence with Jaspersoft and MySQL, embedded in applications or as a stand-alone service for direct use by your audience.
5:15pm-6:00pm (45m)
Products and Services
Next-gen Flash-based MySQL & NoSQL Solutions: Case Studies of Extreme Performance, Scalability, and Availability
Darpan Dinker (Schooner Information Technology, Inc.)
Scale out websites are realizing order-of-magnitude improvements in performance, scalability, and availability while reducing TCO with tightly coupled, flash-based MySQL and NoSQL solutions. Darpan Dinker, Vice President of Database Technologies, Schooner Information Technology, discusses these innovative MySQL and NoSQL solutions, and presents case studies of their large scale deployments.
12:40pm-2:00pm (1h 20m)
Break: Lunch
8:00am-6:00pm (10h)
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 Dolphin
Edward Screven (Oracle Corporation)
Join Edward Screven, Oracle’s Chief Corporate Architect and leader of the MySQL business, as he discusses the current and future state of MySQL, now part of the Oracle family of products. The presentation also covers Oracle’s investment in MySQL technology and community; and the role that open source in general is playing within heterogeneous customer environments around the world.
9:15am-10:00am (45m)
Keynote
O'Reilly Radar
Tim O'Reilly (O'Reilly Media, Inc.)
Tim returns to share insights into the world of emerging technology, presenting his take on what matters most-and what will be most disruptive-to the tech community.
10:00am-10:20am (20m)
Keynote
MySQL at Facebook
Mark Callaghan (Facebook)
Many things happen when MySQL is part of the core technology used to
scale a rapidly growing social networking service. Mark will share
stories and details about the MySQL deployment at Facebook.
9:00pm-11:00pm (2h)
MySQL Conference & Expo Tweetup
Join fellow MySQL Conference & Expo participants at this fun and exciting event. Come together, meet each other face to face, and discuss things in real time over a drink at the bar for the first MySQL CE Tweetup.
10:20am-10:50am (30m)
Break: Morning Break
3:50pm-4:25pm (35m)
Break: Afternoon Break: Located in Expo Hall
6:00pm-7:00pm (1h)
Expo Hall Reception
Visit the exhibitors, mingle with other attendees, and enjoy great refreshments and drinks at the evening reception.
10:00am-4:30pm (6h 30m)
Career Zone
Join participating sponsors, exhibitors, and Nelson Staffing agency as they present open positions from their respective companies.
7:00pm-10:00pm (3h)
Birds of a Feather Networking Sessions
Birds of a Feather (BoF) sessions provide face-to-face exposure to those interested in the same projects and concepts. BoFs can be organized for individual projects or broader topics (best practices, open data, standards). BoFs are entirely up to you. We post your topic online and onsite and provide the space and time. You provide the engaging topic.
Founding Sponsor
Platinum Sponsor
Gold Sponsors
Joint Gold Sponsors
Premier Media Partner
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.