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 Securich - A Security and User Administration plugin for MySQL to your personal schedule
10:50am Securich - A Security and User Administration plugin for MySQL Darren Cassar (Trading Screen Inc)
Add Advanced Sharding Techniques with Spider to your personal schedule
11:55am Advanced Sharding Techniques with Spider Kentoku SHIBA (WildGrowth), Daniel Saito (MySQL)
Add More Mastering the Art of Indexing to your personal schedule
2:00pm More Mastering the Art of Indexing Yoshinori Matsunobu (DeNA)
Add Galera - Synchronous Multi-master Replication For InnoDB to your personal schedule
3:05pm Galera - Synchronous Multi-master Replication For InnoDB Seppo Jaakola (Codership), Alexey Yurchenko (Codership)
Add Time Zones and MySQL to your personal schedule
4:25pm Time Zones and MySQL Sheeri K. Cabral (Mozilla Foundation)
Add Using Visual Studio 2010 With MySQL to your personal schedule
5:15pm Using Visual Studio 2010 With MySQL Reggie Burnett (Oracle), Mike Frank (Gazzang, Inc.)
Ballroom B
Add Partitioning Under the Hood in MySQL 5.5 to your personal schedule
10:50am Partitioning Under the Hood in MySQL 5.5 Mattias Jonsson (Sun Microsystems), Mikael Ronstrom (MySQL)
Add MySQL Cluster - Deployment Best Practices to your personal schedule
11:55am MySQL Cluster - Deployment Best Practices Johan Andersson (SUN MySQL), Joffrey Michaie (SkySQL Ab)
Add Using BlackRay As a Storage Engine to your personal schedule
2:00pm Using BlackRay As a Storage Engine Felix Schupp (SoftMethod GmbH)
Add MySQL Cluster and Pushdown-joins (In Pursuit of the Holy Grail) to your personal schedule
3:05pm MySQL Cluster and Pushdown-joins (In Pursuit of the Holy Grail) Jonas Oreland (Sun Microsystems)
Add Get Your Replication On: Advanced Techniques, Tips and Tricks to your personal schedule
4:25pm Get Your Replication On: Advanced Techniques, Tips and Tricks Sarah Sproehnle (Cloudera, Inc.), Chris Schneider (Ning.com)
Add MySQL Binary Log Analysis With Pentaho BI to your personal schedule
5:15pm MySQL Binary Log Analysis With Pentaho BI Roger Booth (WebAssign)
Ballroom C
Add The Thinking Person’s Guide to Data Warehouse Design to your personal schedule
10:50am The Thinking Person’s Guide to Data Warehouse Design Robin Schumacher (Calpont)
Add PHP Object-Relational Mapping Libraries In Action to your personal schedule
11:55am PHP Object-Relational Mapping Libraries In Action Fernando Ipar (Percona)
Add Boosting Database Performance with Gearman to your personal schedule
3:05pm Boosting Database Performance with Gearman Eric Day (craigslist), Giuseppe Maxia (Continuent)
Add Large Deployment Best Practices to your personal schedule
4:25pm Large Deployment Best Practices Nicklas Westerlund (Electronic Arts)
Add Security Around MySQL to your personal schedule
5:15pm Security Around MySQL Danil Zburivsky (The Pythian Group)
Ballroom D
Add Want Faster Queries? to your personal schedule
11:55am Want Faster Queries? Sarah Sproehnle (Cloudera, Inc.)
Add  MySQL Cluster Performance Tuning Best Practices to your personal schedule
2:00pm MySQL Cluster Performance Tuning Best Practices Johan Andersson (SUN MySQL), Jimmy Guerrero (Oracle-MySQL)
Add Backup Strategies with InnoDB Hot Backup to your personal schedule
3:05pm Backup Strategies with InnoDB Hot Backup John Russell (Oracle Corporation), Calvin Sun (Twitter)
Add Panel: How Solid-state Technologies are Transforming MySQL Server Performance and the Datacenter Architectures to your personal schedule
5:15pm Panel: How Solid-state Technologies are Transforming MySQL Server Performance and the Datacenter Architectures Sumeet Bansal (Fusion-io), Ryan White (Cloudmark), Dan Marriott (Answers.com), Vadim Tkachenko (Percona Inc), Jeremy Zawodny (craigslist.org)
Ballroom E
Add Not Your Grandpa’s Replication-The New Wave of MySQL Replication and How It Helps Your Applications to your personal schedule
11:55am Not Your Grandpa’s Replication-The New Wave of MySQL Replication and How It Helps Your Applications Robert Hodges (Continuent.com), Jay Pipes (Rackspace Cloud)
Add The MariaDB/MySQL Query Executor In-depth to your personal schedule
2:00pm The MariaDB/MySQL Query Executor In-depth Timour Katchaounov (Monty Program AB)
Add Faster Than Alter - Less Downtime to your personal schedule
3:05pm Faster Than Alter - Less Downtime Chris Schneider (Ning.com)
Ballroom F
Add Mysteries of the Binary Log to your personal schedule
10:50am Mysteries of the Binary Log Chuck Bell (Oracle), Lars Thalmann (Oracle), Mats Kindahl (Oracle)
Add Understanding the Role of IO As a Bottleneck to your personal schedule
11:55am Understanding the Role of IO As a Bottleneck Morgan Tocker (Percona, Inc.)
Add SQL Injection Myths and Fallacies to your personal schedule
2:00pm SQL Injection Myths and Fallacies Bill Karwin (Karwin Software Solutions)
Add Mastering InnoDB Diagnostics  to your personal schedule
3:05pm Mastering InnoDB Diagnostics Harrison Fisk (Facebook)
Add Monitoring and Analyzing MySQL Performance With dim_STAT to your personal schedule
4:25pm Monitoring and Analyzing MySQL Performance With dim_STAT Dimitri KRAVTCHUK (Sun Microsystems / Oracle)
Add Add Real-time Streaming SQL to Your MySQL Skill Set to your personal schedule
5:15pm Add Real-time Streaming SQL to Your MySQL Skill Set Julian Hyde (SQLstream), Steve Herskovitz (SQLstream)
Ballroom G
Add IGNITION  - MySQLcamp for Oracle DBA - Volume I to your personal schedule
10:50am IGNITION - MySQLcamp for Oracle DBA - Volume I Ronald Bradford (EffectiveMySQL)
Add  MariaDB Release 5.1;  What Is It and What to Expect From It to your personal schedule
11:55am MariaDB Release 5.1; What Is It and What to Expect From It Michael Widenius (Monty Program Ab)
Add Where It's At: GeoSpatial MySQL - Part 1 to your personal schedule
2:00pm Where It's At: GeoSpatial MySQL - Part 1 Don Beesing (Alion Science and Technology), John Powell (eMapSite)
Add Where It's At: GeoSpatial MySQL - Part 2 to your personal schedule
3:05pm Where It's At: GeoSpatial MySQL - Part 2 Don Beesing (Alion Science and Technology), John Powell (eMapSite)
Add Stored Procedures - Part 1 to your personal schedule
4:25pm Stored Procedures - Part 1 Tobias Asplund (Marin Software), Konstantin Osipov (MySQL)
Add Stored Procedures - Part 2 to your personal schedule
5:15pm Stored Procedures - Part 2 Konstantin Osipov (MySQL), Tobias Asplund (Marin Software)
Ballroom H
Add Answers to the Scaling Challenge: A Case Study With Answers.com on Scaling With Memcached and MySQL to your personal schedule
10:50am Sponsored by Gear6
Answers to the Scaling Challenge: A Case Study With Answers.com on Scaling With Memcached and MySQL Joaquin Ruiz (Gear6), Dan Marriott (Answers.com)
Add Backing Up Distributed MySQL Applications - Taking a Snapshot of a Thousand Dancing Dolphins to your personal schedule
11:55am Sponsored by Zmanda
Backing Up Distributed MySQL Applications - Taking a Snapshot of a Thousand Dancing Dolphins Chander Kant (Zmanda), Paddy Sreenivasan (Zmanda)
Add Database Operations at Scale to your personal schedule
2:00pm Sponsored by Facebook
Database Operations at Scale Santosh Janardhan (Facebook), Mark Konetchy (Facebook), Ryan Thiessen (Facebook)
Add Scalable, Fast, & Simple: Data Warehousing with InfiniDB to your personal schedule
3:05pm Sponsored by Calpont
Scalable, Fast, & Simple: Data Warehousing with InfiniDB John Weber (Calpont)
Add NorthScale at Zynga: Leveraging Memcached’s New Storage Engine API to Create New Solutions for Production Challenges to your personal schedule
4:25pm Sponsored by NorthScale
NorthScale at Zynga: Leveraging Memcached’s New Storage Engine API to Create New Solutions for Production Challenges Dustin Sallings (NorthScale), Matt Ingenthron (Couchbase, Inc.)
Add Sphinx: Full-text Search in 2010 to your personal schedule
5:15pm Sphinx: Full-text Search in 2010 Andrew Aksyonoff (Sphinx Technologies)
Add Birds of a Feather Networking Sessions to your personal schedule
7:00pm BoF's
Room: Ballroom Foyer
Birds of a Feather Networking Sessions
Expo Hall
Add Career Zone to your personal schedule
10:00am Career Zone
12:40pm Lunch
Room: Pool Area & Santa Clara Ballroom
Add State of Drizzle to your personal schedule
8:30am Plenary
Room: Ballroom EFGH
State of Drizzle Brian Aker (HP)
Add State of MariaDB to your personal schedule
9:15am Plenary
Room: Ballroom EFGH
State of MariaDB Michael Widenius (Monty Program Ab)
Add Under New Management: Next Steps for the Community to your personal schedule
10:00am Plenary
Room: Ballroom EFGH
Under New Management: Next Steps for the Community Sheeri K. Cabral (Mozilla Foundation)
Add Ignite MySQL to your personal schedule
7:00pm Plenary
Room: Ballroom EFGH
Ignite MySQL
Bayshore
10:20am Morning Break: Located in Expo Hall
Room: Exhibit Hall A
3:50pm Afternoon Break: Located in Expo Hall
Room: Exhibit Hall A
10:50am-11:50am (1h) Security and Database Administration
Securich - A Security and User Administration plugin for MySQL
Darren Cassar (Trading Screen Inc)
MySQL Security and User Administration is now made easy. Grant all on *.* no more. With SECURICH it is very easy to grant privileges on all but a few tables, make use of roles (groups of privileges), clone, rename, block or unblock users. You can set password complexity, history, expiry and you can do all this using either command line or an open-source, GUI cross platform tool called SAM-My.
11:55am-12:40pm (45m) Architecture and Technology, Cloud Computing, General, MySQL Cluster and High Availability, Replication and Scale-Out, Storage Engine Development and Optimization
Advanced Sharding Techniques with Spider
Kentoku SHIBA (WildGrowth) et al
Spider and Vertical Partitioning Storage Engine will be introduced by Giuseppe in this Conference. In this session, I'll introduce some additional tips for joinable database sharding using Spider and Vertical Partitioning.
2:00pm-3:00pm (1h) Performance Tuning and Benchmarking
More Mastering the Art of Indexing
Yoshinori Matsunobu (DeNA)
Description: In this session, the speaker will explain some important but not well known indexing topics. Advanced topics such as indexes and lock contentions, how indexes impact MySQL optimizer will be covered. This session is the sequel to "Mastering the Art of Indexing" (http://www.mysqlconf.com/mysql2009/public/schedule/detail/6661), presented at the last MySQL Conference.
3:05pm-3:50pm (45m) Replication and Scale-Out
Galera - Synchronous Multi-master Replication For InnoDB
Seppo Jaakola (Codership) et al
Galera is emerging synchronous multi-master replication method, providing tightly coupled InnoDB clustering solution. Galera has nice features like: * High Availability - no lost transactions * Performance - scalability even with 100% write rate * Transparency - direct MySQL connections MySQL/Galera 0.7 is production-ready GA release
4:25pm-5:10pm (45m) General, Security and Database Administration
Time Zones and MySQL
Sheeri K. Cabral (Mozilla Foundation)
MySQL data types do not support the SQL standard WITH TIME ZONE attribute. How do you store times in MySQL to efficiently show your customers times in their own time zone?
5:15pm-6:00pm (45m) .NET/Windows
Using Visual Studio 2010 With MySQL
Reggie Burnett (Oracle) et al
Visual Studio 2010 is the most exciting release of Visual Studio in years. Now you can use all the database coolness that SQL Server developers have had for years with MySQL.
10:50am-11:50am (1h) Architecture and Technology, Storage Engine Development and Optimization
Partitioning Under the Hood in MySQL 5.5
Mattias Jonsson (Sun Microsystems) et al
Meet the developers behind the partitioning feature in MySQL and take your chance to influence the future development! Get a detailed view of how the partitioning works inside the MySQL server, including the new features in 5.5 (COLUMS partitioning type, truncate partition, MyISAM key cache per partition, etc). And what is in development right now.
11:55am-12:40pm (45m) Architecture and Technology, General, MySQL Cluster and High Availability
MySQL Cluster - Deployment Best Practices
Johan Andersson (SUN MySQL) et al
Getting the most out of your MySQL Cluster (NDB) deployment
2:00pm-3:00pm (1h) Architecture and Technology, Storage Engine Development and Optimization
Using BlackRay As a Storage Engine
Felix Schupp (SoftMethod GmbH)
BlackRay is an open source in-memory relational database. This talk focuses on implementing BlackRay as a storage engine backend for MySQL, thereby leveraging MySQL engine features currently not available natively in BlackRay. Conversely, some shortcomings of the Storage Engine architecture will be discussed as well.
3:05pm-3:50pm (45m) MySQL Cluster and High Availability, Storage Engine Development and Optimization
MySQL Cluster and Pushdown-joins (In Pursuit of the Holy Grail)
Jonas Oreland (Sun Microsystems)
Learn everything about the latest and greatest new feature for MySQL Cluster, pushdown-joins. How it's implemented in the data nodes, how the mysqld integration is done, what the next steps will be and the performance increases that we measured.
4:25pm-5:10pm (45m) Architecture and Technology, Replication and Scale-Out
Get Your Replication On: Advanced Techniques, Tips and Tricks
Sarah Sproehnle (Cloudera, Inc.) et al
This talk is for those that know the basics of replication but want to take it to another level. We will show you how replication can solve complicated problems, give you better performance, and avoid excess downtime.
5:15pm-6:00pm (45m) Architecture and Technology, Data Warehousing and Business Intelligence
MySQL Binary Log Analysis With Pentaho BI
Roger Booth (WebAssign)
Before you throw away the binary logs that you use for replication, transform them into an analysis tool. Use them to track the frequency of inserts, updates and deletes on all of your tables. Maintain a history of the response times of your most frequent write queries.
10:50am-11:50am (1h) Data Warehousing and Business Intelligence
The Thinking Person’s Guide to Data Warehouse Design
Robin Schumacher (Calpont)
Many times, data warehouses are thrown up without much thought going into the logical/ physical design. But, high performance data warehouses and analytic databases don’t happen by accident; they come from solid up-front design work. This session describes the procedures to go from an empty data model to a physical data warehouse that can stand up to terabytes of data and intense user activity.
11:55am-12:40pm (45m) General, PHP and MySQL
PHP Object-Relational Mapping Libraries In Action
Fernando Ipar (Percona)
If you're using or planning to use an Object-Relational Mapping (ORM) library for PHP, this talk is for you. We'll survey common ORMs available and see how to use them, including relevant design patterns. Additionally, we'll examine potential pitfalls that can lead to poor performance and other side effects if you use ORMs in their default manner or without understanding what they do.
2:00pm-3:00pm (1h) Data Warehousing and Business Intelligence
Successful and Cost Effective Data Warehouse... The MySQL Way
Ivan Zoratti (SkySQL)
MySQL is becoming more and more popular as a DB for business intelligence and data warehouse solutions. The implementation of these solutions are often based on an approach that is typical of commercial DBs and expensive HW. In this session we will present the best techniques to use MySQL in a OLAP environment, for modelling, loading, querying, caching and indexing multidimensional DBs.
3:05pm-3:50pm (45m) Architecture and Technology, Replication and Scale-Out
Boosting Database Performance with Gearman
Eric Day (craigslist) et al
Many people view topics like Map/Reduce and queue systems as advanced concepts that require in-depth knowledge and time consuming software setup. Gearman is changing all that by making this barrier to entry as low as possible with an open source, distributed job queuing system. This session looks at advanced use cases that demonstrate the power and flexibility of distributed architectures.
4:25pm-5:10pm (45m) Architecture and Technology, MySQL Cluster and High Availability, Replication and Scale-Out, Security and Database Administration
Large Deployment Best Practices
Nicklas Westerlund (Electronic Arts)
Want to learn what the difference between a 10 server deployment and a 200 server deployment is in terms of administration? Best practices in large deployments? Got questions on centralized management and change management? Capacity planning? All these subjects and more will be covered in this session
5:15pm-6:00pm (45m) Security and Database Administration
Security Around MySQL
Danil Zburivsky (The Pythian Group)
MySQL security usually means strong passwords, proper user@host grants and SSL connectivity. However MySQL does not operate in a void. This talk will focus on how MySQL security can be compromised through the hardware, operating system (using Linux examples), network, and the applications. We will also discuss attack prevention from external and internal sources.
10:50am-11:50am (1h) Architecture and Technology, General, Replication and Scale-Out, Security and Database Administration
Read-Write Splitting: Techniques, Challenges, and Solutions
Baron Schwartz (VividCortex)
Are you interested in splitting your application's reads and writes, so writes go to the master and SELECT queries go to slaves? This session is for you. Learn common patterns, pitfalls, and solutions.
11:55am-12:40pm (45m) General
Want Faster Queries?
Sarah Sproehnle (Cloudera, Inc.)
This talk is for developers or administrators who need to make their queries faster.
2:00pm-3:00pm (1h) General, MySQL Cluster and High Availability, Performance Tuning and Benchmarking
MySQL Cluster Performance Tuning Best Practices
Johan Andersson (SUN MySQL) et al
Are you experiencing current performance bottlenecks in your high availability applications ? Are you designing a new mission-critical application and want to know how best to structure your schema and index strategy for optimal performance? Interested in how to transform your SQL into faster, more efficient queries?
3:05pm-3:50pm (45m) Architecture and Technology
Backup Strategies with InnoDB Hot Backup
John Russell (Oracle Corporation) et al
InnoDB Hot Backup is the ideal solution for online backups of InnoDB tables in MySQL databases, as well as for backups of MyISAM tables. At this session, you will learn how InnoDB Hot Backup works, and how to develop a backup strategy using the Hot Backup utility.
4:25pm-5:10pm (45m) Architecture and Technology, Business and Case Studies, Web 2.0, Ajax, and Emerging Technologies
Choosing the Right Tools for the Job, SQL or NOSQL
Matt Yonkovit (Percona)
Explore options outside the traditional RDBMS during this high level tour of some common application architectures. We will discuss how these tools differ, where they fit, and how they can be used collaboratively to build an application with the best of all the worlds.
5:15pm-6:00pm (45m) Architecture and Technology, MySQL Cluster and High Availability, Performance Tuning and Benchmarking, Replication and Scale-Out
Panel: How Solid-state Technologies are Transforming MySQL Server Performance and the Datacenter Architectures
Sumeet Bansal (Fusion-io) et al
This panel discussion, moderated by Sumeet Bansal, principal solutions architect for Fusion-io, the solid-state storage provider, will make clear to audience members the benefits of solid-state technologies, both from a performance standpoint and in relation to TCO. Q&A with the panel to follow. Participants include panelists from Answers.com, Cloudmark, Percona and Craigslist.org.
10:50am-11:50am (1h) Security and Database Administration
Making MySQL Administration a Breeze - A Look Into a MySQL DBA's Toolchest
Lenz Grimmer (Sun Microsystems)
The MySQL Server ships with a number of command-line administration tools. However, they only provide basic functionality and make it complicated or sometimes even impossible to accomplish common DBA tasks. In this session, Lenz will give an introduction to the most popular and commonly used Open Source tools that a DBA should be aware of and that make MySQL administration tasks a breeze.
11:55am-12:40pm (45m) Architecture and Technology, LAMP, Replication and Scale-Out
Not Your Grandpa’s Replication-The New Wave of MySQL Replication and How It Helps Your Applications
Robert Hodges (Continuent.com) et al
Replication is big news and not just because of built-in replication from MySQL itself. Projects like Drizzle, Tungsten, and Galera are changing the replication game with higher speed and greater flexibility than ever before. Join Jay Pipes (Drizzle Replication API) and Robert Hodges (Tungsten Clustering) for a tour of the new replication solutions and how they can help your applications.
2:00pm-3:00pm (1h) Architecture and Technology
The MariaDB/MySQL Query Executor In-depth
Timour Katchaounov (Monty Program AB)
One of the key elements of database expertise is understanding how queries are executed. This talk gives a detailed and consistent overview of query execution in MariaDB/MySQL covering both algorithms, code, internal and external representations of query plans. Deeper understanding of this area should benefit both current and future server and storage engine developers, and DBAs.
3:05pm-3:50pm (45m) Business and Case Studies, Performance Tuning and Benchmarking
Faster Than Alter - Less Downtime
Chris Schneider (Ning.com)
Ever wanted to de-fragment your data set to regain disk space and increase performance? Ever needed to add or change an index on a large table? Ever needed to change a primary key? If you answered yes to any of these and you already know a lot about MySQL then this talk is for you!
4:25pm-5:10pm (45m) Architecture and Technology, Performance Tuning and Benchmarking, Storage Engine Development and Optimization
InnoDB Architecture and Performance Optimization - Part 1
Peter Zaitsev (Percona Inc)
This presentation will teach you the InnoDB internals you need to know for performance optimization and operational tasks. You'll learn topics such as how InnoDB allocates space on the filesystem and in memory, how InnoDB recovery works, and how MVCC and locking work.
5:15pm-6:00pm (45m) Architecture and Technology, Performance Tuning and Benchmarking, Storage Engine Development and Optimization
InnoDB Architecture and Performance Optimization - Part 2
Peter Zaitsev (Percona Inc)
This presentation will teach you the InnoDB internals you need to know for performance optimization and operational tasks. You'll learn topics such as how InnoDB allocates space on the filesystem and in memory, how InnoDB recovery works, and how MVCC and locking work.
10:50am-11:50am (1h) Replication and Scale-Out
Mysteries of the Binary Log
Chuck Bell (Oracle) et al
The binary log is a critical part of replication, but it can also be used for point-in-time recovery and auditing purposes. In this session, we present a thorough description of the binary log structure, the replication events, and how to use the mysqlbinlog tool to investigate and work with the contents of binary logs.
11:55am-12:40pm (45m) LAMP, MySQL Cluster and High Availability, Performance Tuning and Benchmarking, Security and Database Administration
Understanding the Role of IO As a Bottleneck
Morgan Tocker (Percona, Inc.)
Disks are often credited with being the biggest performance bottleneck to any database system. This session introduces you to Linux diagnostic tools, hardware purchasing options, and how you should be thinking about IO.
2:00pm-3:00pm (1h) PHP and MySQL, Security and Database Administration
SQL Injection Myths and Fallacies
Bill Karwin (Karwin Software Solutions)
SQL Injection is one of the most common and most serious threats to web application security. In this presentation, you'll see some myths busted, you'll get a better understanding of SQL Injection, and you'll learn simple and effective techniques to combat it.
3:05pm-3:50pm (45m) Architecture and Technology, Performance Tuning and Benchmarking, Security and Database Administration
Mastering InnoDB Diagnostics
Harrison Fisk (Facebook)
InnoDB provides many sources of diagnostic information. Filtering through that information to find what is wrong with a system can be a big task. This talk with detail all of the different sources and what useful information you can get from them. In addition, it will offer common solutions for these problems to get you started in the right direction.
4:25pm-5:10pm (45m) Performance Tuning and Benchmarking, Security and Database Administration
Monitoring and Analyzing MySQL Performance With dim_STAT
Dimitri KRAVTCHUK (Sun Microsystems / Oracle)
dim_STAT is a very powerful tool to monitor and analyze everything you need from your server. This presentation will cover MySQL oriented solutions integrated within dim_STAT.
5:15pm-6:00pm (45m) Architecture and Technology, Business and Case Studies, Web 2.0, Ajax, and Emerging Technologies
Add Real-time Streaming SQL to Your MySQL Skill Set
Julian Hyde (SQLstream) et al
Need instant results to your queries? Learn how to become a real-time data and analytics expert by adding Streaming SQL to your MySQL skill set. SQLstream's streaming SQL architects will introduce you to key concepts in Stream Computing using SQL:2008 & MySQL, followed by real world examples
10:50am-11:50am (1h) Architecture and Technology, Migration
IGNITION - MySQLcamp for Oracle DBA - Volume I
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
MariaDB Release 5.1; What Is It and What to Expect From It
Michael Widenius (Monty Program Ab)
What is the MariaDB 5.1 release, who should use it and for what.
2:00pm-3:00pm (1h) Tutorial, Web 2.0, Ajax, and Emerging Technologies
Where It's At: GeoSpatial MySQL - Part 1
Don Beesing (Alion Science and Technology) et al
Not primarily thought of as a geospatial data store, MySQL is making huge strides in this field. A branch is being developed on MySQL forge that is implementing all functionality defined by the Open GeoSpatial Consortium(OGC). This tutorial will combine a geospatial programming crash course with real world examples integrating MySQL geospatial storage and functionality into existing applications.
3:05pm-3:50pm (45m) Web 2.0, Ajax, and Emerging Technologies
Where It's At: GeoSpatial MySQL - Part 2
Don Beesing (Alion Science and Technology) et al
Not primarily thought of as a geospatial data store, MySQL is making huge strides in this field. A branch is being developed on MySQL forge that is implementing all functionality defined by the Open GeoSpatial Consortium(OGC). This tutorial will combine a geospatial programming crash course with real world examples integrating MySQL geospatial storage and functionality into existing applications.
4:25pm-5:10pm (45m) Architecture and Technology
Stored Procedures - Part 1
Tobias Asplund (Marin Software) et al
Two MySQL engineers who have worked on developing stored procedures or related features will walk through the whole thing.
5:15pm-6:00pm (45m) Architecture and Technology
Stored Procedures - Part 2
Konstantin Osipov (MySQL) et al
Two MySQL engineers who have worked on developing stored procedures or related features will walk through the whole thing.
10:50am-11:50am (1h) Products and Services
Answers to the Scaling Challenge: A Case Study With Answers.com on Scaling With Memcached and MySQL
Joaquin Ruiz (Gear6) et al
Many LAMP websites use Memcached to offload dynamic data from their MySQL database to speed up performance. Answers.com, however, did not want to be in the business of managing a growing Memcached layer. In this case study, Answers.com discusses its choices when it came to scaling out with Memcached and the lessons learned.
11:55am-12:40pm (45m) Products and Services
Backing Up Distributed MySQL Applications - Taking a Snapshot of a Thousand Dancing Dolphins
Chander Kant (Zmanda) et al
Increasing number of large MySQL applications, e.g. social networking back-ends, use a distributed MySQL architecture. Backing up such large environments presents its own complexities. Application managers want a point-in-time restore which is coordinated across multiple servers. We will discuss multiple techniques to solve this problem and provide trade-offs based on on-the-ground experiences.
2:00pm-3:00pm (1h) Products and Services
Database Operations at Scale
Santosh Janardhan (Facebook) et al
Database operations gets interesting when it involves several thousand databases, a high-profile site and you have a small core team of DBAs. Among other things, we will give a high-level overview of Facebook database architecture, Backup (and recovery) strategy and the mysql upgrade process.
3:05pm-3:50pm (45m) Products and Services
Scalable, Fast, & Simple: Data Warehousing with InfiniDB
John Weber (Calpont)
InfiniDB is a scalable, column-oriented database purpose-built for data warehousing and analytical workloads. Session attendees will learn how to leverage InfiniDB to build a future-proof information management infrastructure that can continually scale to meet evolving user, data and performance needs.
4:25pm-5:10pm (45m) Products and Services
NorthScale at Zynga: Leveraging Memcached’s New Storage Engine API to Create New Solutions for Production Challenges
Dustin Sallings (NorthScale) et al
Everyone knows memcached is useful for alleviating database load. What may be less well known is that memcached’s new storage engine API allows you to create new solutions for myriad needs, building on what makes memcached fast and simple. This discussion of the storage engine API includes a case study of its use at Zynga, where NorthScale Membase Server is the key-value database behind FarmVille.
5:15pm-6:00pm (45m) LAMP, Performance Tuning and Benchmarking, Replication and Scale-Out
Sphinx: Full-text Search in 2010
Andrew Aksyonoff (Sphinx Technologies)
Sphinx is a FOSS full-text search engine that makes searching MySQL databases a breeze. This talk covers a number of recently developed advanced Sphinx features (RT indexes, parallel searching improvements, subquery caches, hitless indexes, "blended" indexing, SphinxQL interface, etc) in detail, explaining how and why to use them in your application.
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.
10:00am-5:00pm (7h)
Career Zone
Join participating sponsors, exhibitors, and Nelson Staffing agency as they present open positions from their respective companies.
12:40pm-2:00pm (1h 20m)
Break: Lunch
8:30am-9:15am (45m) Keynote
State of Drizzle
Brian Aker (HP)
What's the forecast for Drizzle, a database optimized for Cloud and Net applications? Brian provides an overview of the Drizzle project's current state as well as what's ahead.
9:15am-10:00am (45m) Keynote
State of MariaDB
Michael Widenius (Monty Program Ab)
Monty, the co-founder of MySQL and now project lead of MariaDB, discusses what MariaDB is all about. He'll also present an overview of the future of this community developed branch of the MySQL database.
10:00am-10:20am (20m) Keynote
Under New Management: Next Steps for the Community
Sheeri K. Cabral (Mozilla Foundation)
Sheeri Cabral knows the MySQL Community. Working for the Pythian Group, she has tapped her co-workers' knowledge about the Oracle Community. In this brief community keynote, Sheeri maps out the differences between the communities and what we can expect next now that MySQL is "under new management".
7:00pm-8:30pm (1h 30m)
Ignite MySQL
If you had five minutes on stage what would you say? What if you only got 20 slides and they rotated automatically after 15 seconds? Would you pitch a project? Launch a web site? Teach a hack? We’re going to find out when we try our first Ignite event at MySQL Conference & Expo.
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.
10:20am-10:50am (30m)
Break: Morning Break: Located in Expo Hall
3:50pm-4:25pm (35m)
Break: Afternoon Break: Located in Expo Hall
  • 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.