O'Reilly MySQL Conference & Expo 2010 Full 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.

Monday, 04/12/2010

8:30am

Add to your personal schedule
Monday, 04/12/2010
Andrew Morgan (Oracle), Geert Vanderkelen (Sun Microsystems), Andrew Hutchings (Hewlett-Packard)
Average rating: ***..
(3.50, 6 ratings)
This tutorial aims to guide normal MySQL users and DBAs into the world of MySQL Cluster. From installing and configuring to creating your first clustered table and finally node failure handling. At the end of the session you'll will be the proud owner of a full blown, tiny MySQL Cluster which you can show off at work. Read more.
Add to your personal schedule
Monday, 04/12/2010
Sheeri K. Cabral (Mozilla Foundation)
Average rating: ***..
(3.25, 4 ratings)
Unlock all the information the MySQL server can give you! MySQL has many status variables that show how well your environment utilizes its resources. There are many system variables that can be set and changed to tune the server. Read more.
Add to your personal schedule
Monday, 04/12/2010
Arjen Lentz (Open Query), Walter Heck (Open Query)
Average rating: *....
(1.83, 6 ratings)
Implementing multi-master setups with MySQL is fairly trivial in basic terms, but for an effective environment much more is involved. There are some tools (such as MMM, Multi-Master MySQL Manager) that can help, but there's still a lot to think of and each deployment is different. Read more.
Add to your personal schedule
Monday, 04/12/2010
Replication and Scale-Out, Tutorial
Location: Ballroom E
Mats Kindahl (Oracle), Lars Thalmann (Oracle)
Average rating: ****.
(4.14, 7 ratings)
Although MySQL Replication is easy to set up and easy to configure, it is nevertheless a very versatile tool that can be used to solve many problems in modern applications. Read more.
Add to your personal schedule
Monday, 04/12/2010
Giuseppe Maxia (Continuent)
Average rating: ****.
(4.17, 6 ratings)
MySQL 5.1 introduces partitioning – a very useful feature for databases with large tables. The latest release, MySQL 5.5 enhances partitioning to make them even more user friendly and powerful. This tutorial explains the basics, and some advanced techniques to get the most from partitioning. Read more.
Add to your personal schedule
Monday, 04/12/2010
Baron Schwartz (VividCortex), Morgan Tocker (Percona, Inc.)
Average rating: ****.
(4.33, 18 ratings)
This tutorial focuses on the diagnostic tools you can turn to when confronted with an unexplained performance problem. Tools explained include iostat, vmstat, and mk-query-digest. The emphasis is on practical usage under pressure, and less on performance theory. Read more.
Add to your personal schedule
Monday, 04/12/2010
Architecture and Technology, Tutorial
Location: Ballroom H
Kai Voigt (Sun Microsystems)
Average rating: ****.
(4.22, 9 ratings)
Wanna be a Certified MySQL DBA? This Tutorial summarizes every chapter covered in the first part of the official MySQL DBA Exam. Join the tutorial, take and pass the exam during the conference. Read more.

12:00pm

Monday, 04/12/2010
Location: Pool Area & Santa Clara Ballroom
LUNCH (1h 30m)

1:30pm

Add to your personal schedule
Monday, 04/12/2010
Sheeri K. Cabral (Mozilla Foundation)
Average rating: ***..
(3.38, 8 ratings)
Unlock all the information the MySQL server can give you! MySQL has many status variables that show how well your environment utilizes its resources. There are many system variables that can be set and changed to tune the server. Read more.
Add to your personal schedule
Monday, 04/12/2010
Toru Maesaka (mixi, Inc)
Average rating: ****.
(4.00, 2 ratings)
Drizzle is a fork of the MySQL server that has been talked about for some time. This tutorial will cover how the Storage Engine API and its subsystem has evolved. We will walk through the API with BlitzDB, a storage engine that is built on top of this new storage subsystem. Read more.
Add to your personal schedule
Monday, 04/12/2010
Brian Aker (HP), Alan Kasindorf (Six Apart)
Average rating: ****.
(4.25, 4 ratings)
We’ve been talking about memcached for a while now. The topic is exciting, scary, and constantly evolving. You might have a hard time understanding how memcached works at all. You might be missing the “big picture”, or you might just need a handful of examples of how to properly handle common queries. Come here to learn more from the experts! Read more.
Add to your personal schedule
Monday, 04/12/2010
Giuseppe Maxia (Continuent)
Average rating: ****.
(4.29, 7 ratings)
Command line skills for administering and using MySQL are still one of the main requirements for professionals in the Unix world. This tutorial provides the basics and several advanced techniques. Read more.
Add to your personal schedule
Monday, 04/12/2010
Jay Pipes (Rackspace Cloud), Padraig O'Sullivan (Akiban Technologies Inc.)
Average rating: ****.
(4.00, 1 rating)
The Drizzle Project is a fork of the MySQL 6.0 server. One of the many goals of Drizzle is to enable a large plugin ecosystem by improving, simplifying, and modernizing the application programming interfaces between the kernel and the modules providing services for Drizzle. This tutorial serves to showcase the new APIs for Drizzle's replication through a series of in-depth examples. Read more.
Add to your personal schedule
Monday, 04/12/2010
Peter Zaitsev (Percona Inc)
Average rating: ***..
(3.07, 14 ratings)
Scaling Applications with Caching, Sharding and Replication Read more.
Add to your personal schedule
Monday, 04/12/2010
Architecture and Technology, Tutorial
Location: Ballroom H
Kai Voigt (Sun Microsystems)
Average rating: ****.
(4.57, 7 ratings)
Wanna be a Certified MySQL DBA? This Tutorial summarizes every chapter covered in the second part of the official MySQL DBA Exam. Join the tutorial, take and pass the exam during the conference. Read more.

Tuesday, 04/13/2010

8:00am

Add to your personal schedule
Tuesday, 04/13/2010
Location: Bayshore
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. Read more.

8:30am

Add to your personal schedule
Tuesday, 04/13/2010
Location: Ballroom EFGH
Edward Screven (Oracle Corporation)
Average rating: ***..
(3.17, 29 ratings)
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. Read more.

9:15am

Add to your personal schedule
Tuesday, 04/13/2010
Location: Ballroom EFGH
Tim O'Reilly (O'Reilly Media, Inc.)
Average rating: ****.
(4.29, 28 ratings)
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. Read more.

10:00am

Add to your personal schedule
Tuesday, 04/13/2010
Location: Ballroom EFGH
Mark Callaghan (Facebook)
Average rating: ***..
(3.95, 21 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Location: Expo Hall
Join participating sponsors, exhibitors, and Nelson Staffing agency as they present open positions from their respective companies. Read more.

10:50am

Add to your personal schedule
Tuesday, 04/13/2010
Eric Day (craigslist), Monty Taylor (HP)
Average rating: ****.
(4.00, 1 rating)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Replication and Scale-Out
Location: Ballroom B
Domas Mituzas (Facebook)
Average rating: ****.
(4.23, 22 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Rob Young (Oracle/MySQL ), Mikael Ronstrom (MySQL)
Average rating: **...
(2.78, 9 ratings)
Join the MySQL and InnoDB Engineering teams as they describe the low-level technical details behind the MySQL 5.5 performance and scalability gains. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Grant McAlister (Amazon.com)
Average rating: *....
(1.33, 3 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Bernhard Ocklin (Sun Microsystems AB), Andrew Morgan (Oracle)
Average rating: ***..
(3.50, 2 ratings)
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 Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Business and Case Studies
Location: Ballroom F
Kurt von Finck (Monty Program Ab)
Average rating: *....
(1.00, 1 rating)
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! Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Products and Services
Location: Ballroom G
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Products and Services
Location: Ballroom H
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. Read more.

11:55am

Add to your personal schedule
Tuesday, 04/13/2010
Padraig O'Sullivan (Akiban Technologies Inc.)
Average rating: ****.
(4.00, 5 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Geert Vanderkelen (Sun Microsystems)
Average rating: ****.
(4.75, 4 ratings)
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). Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Products and Services
Location: Ballroom C
Mikael Ronstrom (MySQL)
Join the MySQL and InnoDB Engineering teams to examine the eye popping MySQL 5.5 performance and scalability benchmarks. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Giuseppe Maxia (Continuent), Kentoku SHIBA (WildGrowth)
Average rating: ***..
(3.44, 9 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Aaron Kimball (Cloudera, Inc.)
Average rating: ***..
(3.67, 3 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Peter Gulutzan (MySQL AB)
Average rating: ***..
(3.70, 10 ratings)
Performance Schema is a major new MySQL Server feature which shows where we're going with monitoring and performance measurement. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Products and Services
Location: Ballroom G
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Products and Services
Location: Ballroom H
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... Read more.

2:00pm

Add to your personal schedule
Tuesday, 04/13/2010
Mats Kindahl (Oracle), Lars Thalmann (Oracle)
Average rating: ***..
(3.77, 13 ratings)
In this talk, the developers behind MySQL Replication walk through some of the new Replication features of MySQL 5.5 Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Migration
Location: Ballroom B
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Baron Schwartz (VividCortex)
Average rating: ****.
(4.27, 11 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Brian Moon (dealnews.com)
Average rating: ***..
(3.50, 2 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Paul McCullagh (PrimeBase Technologies GmbH)
Average rating: *****
(5.00, 3 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Cloud Computing
Location: Ballroom F
Alex Esterkin (Open Source Community)
Average rating: *....
(1.33, 3 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Products and Services
Location: Ballroom G
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Products and Services
Location: Ballroom H
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. Read more.

3:05pm

Add to your personal schedule
Tuesday, 04/13/2010
Geert Vanderkelen (Sun Microsystems)
Average rating: ***..
(3.00, 2 ratings)
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). Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Jimmy Yang (Oracle Corporation)
Average rating: **...
(2.60, 15 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Giuseppe Maxia (Continuent), Eric Day (craigslist)
Average rating: ***..
(3.33, 3 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Migration
Location: Ballroom D
Average rating: **...
(2.00, 3 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Ruby and MySQL
Location: Ballroom E
David Berube (Berube Consulting)
Average rating: ***..
(3.50, 2 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Matt Casters (Pentaho)
Average rating: ****.
(4.00, 2 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Products and Services
Location: Ballroom G
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Architecture and Technology
Location: Ballroom H
Rob Young (Oracle/MySQL ), Calvin Sun (Twitter)
Average rating: *....
(1.50, 8 ratings)
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. Read more.

4:25pm

Add to your personal schedule
Tuesday, 04/13/2010
Robert Hamel (Pythian)
Average rating: ****.
(4.00, 8 ratings)
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 Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Mark Matthews (Oracle), Todd Farmer (Oracle Corporation)
Average rating: **...
(2.40, 5 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Roland Bouman (XCDSQL Solutions / Strukton Rail)
Average rating: ***..
(3.75, 8 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Robert Hodges (Continuent.com)
Average rating: ****.
(4.00, 2 ratings)
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! Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Vadim Tkachenko (Percona Inc), Morgan Tocker (Percona, Inc.)
Average rating: ***..
(3.50, 6 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Matt Yonkovit (Percona)
Average rating: ****.
(4.57, 7 ratings)
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? Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Location: Ballroom G
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Products and Services
Location: Ballroom H
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. Read more.

5:15pm

Add to your personal schedule
Tuesday, 04/13/2010
Architecture and Technology
Location: Ballroom A
Sergei Golubchik (MariaDB)
Average rating: ***..
(3.00, 1 rating)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Average rating: ****.
(4.56, 18 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Replication and Scale-Out
Location: Ballroom C
Jan Kneschke (MySQL)
Average rating: ***..
(3.00, 2 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Ben Black (Garmin), Mark Filipi (Garmin International)
Average rating: ***..
(3.00, 3 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Architecture and Technology
Location: Ballroom E
Average rating: **...
(2.00, 3 ratings)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Architecture and Technology
Location: Ballroom F
Arjen Lentz (Open Query), Antony Curtis (Blizzard Entertainment)
Average rating: ****.
(4.00, 1 rating)
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. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Products and Services
Location: Ballroom G
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. Read more.
Tuesday, 04/13/2010
Location: Ballroom H
TBC

6:00pm

Add to your personal schedule
Tuesday, 04/13/2010
Location: Exhibit Hall A
Average rating: ***..
(3.50, 6 ratings)
Visit the exhibitors, mingle with other attendees, and enjoy great refreshments and drinks at the evening reception. Read more.

7:00pm

Add to your personal schedule
Tuesday, 04/13/2010
Location: Ballroom A
Moderated by: Antony Curtis
Session to discuss plugable stored procedure framework for users and developers. Using Perl, Java and other languages for writing stored procedures. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Location: Ballroom B
Moderated by: Stewart Smith
BoF for those wanting to discuss the Drizzle Database Server, where it fits it, what it can do, it's current status etc. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Location: Ballroom C
Moderated by: Anders Karlsson
Database systems as a distinct software technology is now coming of age, and it is time to look at the history. Where did it start, what was driving the changes, what made SQL so successful and what is the next big thing? With so many database professionals at one place with diverse backgrounds, this could turn into a real interesting debate. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Location: Ballroom D
Moderated by: Baron Schwartz
Average rating: ****.
(4.67, 3 ratings)
Discussion of all things Maatkit, hosted by Maatkit's creator. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Location: Ballroom E
Moderated by: Matt Ingenthron
Nearly everyone has heard of memcached, and many have used it. Frequently though, the simple methods of integrating memcached into an app are apparent. The more complex usages require more thought and delving into multiget, CAS operations and other memcached capabilities. Join this session to exchange ideas between other users and developers of the memcached server and clients. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Location: Ballroom H
Moderated by: Andrew Aksyonoff
Average rating: *****
(5.00, 1 rating)
Open discussion of everything related to full text searching in databases, moderated by Sphinx (free, open-source engine) author. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Location: Ballroom Foyer
Average rating: *....
(1.00, 1 rating)
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. Read more.

8:00pm

Add to your personal schedule
Tuesday, 04/13/2010
Location: Ballroom A
Moderated by: Mark Matthews
Get together with the developers who work on the Java technologies for MySQL and let's talk shop Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Location: Ballroom B
BoF for folks using or interested in MySQL Workbench - development, design and administration, what it does, how it works, things you'd like to see, tell us how you use it, like's and dislike's. Explore how Workbench 5.2 includes features of MySQL Query Browser and MySQL Administrator. So come meet with the Workbench Team and lets talk, meet, and throw out some cool ideas. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Location: Ballroom C
In this session the replication leads will be available to discuss replication, answer questions, and maybe you will see some of the ideas that are boiling inside the replication team. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Location: Ballroom D
Moderated by: Paul Vallee or Sheeri Cabral
Wondering what’s next on the horizon for MySQL? Join this BoF, and find out the scoop. As both a MySQL Platinum Partner and Oracle Platinum Partner, Pythian has both sides of the story covered - we’ll share what we think and why. Open discussion is encouraged! Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Location: Ballroom E
Moderated by: Craig Russell
Discussion of MySQL Cluster and the new features in the latest release -- including the new Cluster/J native Java API, and OpenJPA support. Read more.
Add to your personal schedule
Tuesday, 04/13/2010
Location: Ballroom H
Moderated by: Lee Stigile
This is an opportunity for ISVs and OEMs to directly ask questions of MySQL experts and discuss topics that aren't always addressed in the more general MySQL forums, such as installation, deployment, security, zero admin, using libmysqld and whatever else that's of interest or concern to you. Read more.

9:00pm

Add to your personal schedule
Tuesday, 04/13/2010
Location: Lobby Bar
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. Read more.

Wednesday, 04/14/2010

8:00am

Add to your personal schedule
Wednesday, 04/14/2010
Location: Bayshore
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. Read more.

8:30am

Add to your personal schedule
Wednesday, 04/14/2010
Location: Ballroom EFGH
Brian Aker (HP)
Average rating: ****.
(4.04, 27 ratings)
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. Read more.

9:15am

Add to your personal schedule
Wednesday, 04/14/2010
Location: Ballroom EFGH
Michael Widenius (Monty Program Ab)
Average rating: **...
(2.73, 22 ratings)
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. Read more.

10:00am

Add to your personal schedule
Wednesday, 04/14/2010
Location: Ballroom EFGH
Sheeri K. Cabral (Mozilla Foundation)
Average rating: **...
(2.09, 23 ratings)
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". Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Location: Expo Hall
Join participating sponsors, exhibitors, and Nelson Staffing agency as they present open positions from their respective companies. Read more.

10:50am

Add to your personal schedule
Wednesday, 04/14/2010
Darren Cassar (Trading Screen Inc)
Average rating: ***..
(3.50, 4 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Mattias Jonsson (Sun Microsystems), Mikael Ronstrom (MySQL)
Average rating: **...
(2.71, 7 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Robin Schumacher (Calpont)
Average rating: ****.
(4.38, 8 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Baron Schwartz (VividCortex)
Average rating: ****.
(4.12, 8 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Lenz Grimmer (Sun Microsystems)
Average rating: ****.
(4.70, 10 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Replication and Scale-Out
Location: Ballroom F
Chuck Bell (Oracle), Lars Thalmann (Oracle), Mats Kindahl (Oracle)
Average rating: ***..
(3.57, 7 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Architecture and Technology, Migration
Location: Ballroom G
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Products and Services
Location: Ballroom H
Joaquin Ruiz (Gear6), Dan Marriott (Answers.com)
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. Read more.

11:55am

Add to your personal schedule
Wednesday, 04/14/2010
Kentoku SHIBA (WildGrowth), Daniel Saito (MySQL)
Average rating: ***..
(3.00, 3 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Johan Andersson (SUN MySQL), Joffrey Michaie (SkySQL Ab)
Average rating: ***..
(3.83, 6 ratings)
Getting the most out of your MySQL Cluster (NDB) deployment Read more.
Add to your personal schedule
Wednesday, 04/14/2010
General, PHP and MySQL
Location: Ballroom C
Fernando Ipar (Percona)
Average rating: ***..
(3.50, 2 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
General
Location: Ballroom D
Sarah Sproehnle (Cloudera, Inc.)
Average rating: ****.
(4.00, 11 ratings)
This talk is for developers or administrators who need to make their queries faster. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Robert Hodges (Continuent.com), Jay Pipes (Rackspace Cloud)
Average rating: ***..
(3.20, 5 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Morgan Tocker (Percona, Inc.)
Average rating: ****.
(4.38, 8 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Architecture and Technology
Location: Ballroom G
Michael Widenius (Monty Program Ab)
Average rating: ***..
(3.50, 4 ratings)
What is the MariaDB 5.1 release, who should use it and for what. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Products and Services
Location: Ballroom H
Chander Kant (Zmanda), Paddy Sreenivasan (Zmanda)
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. Read more.

2:00pm

Add to your personal schedule
Wednesday, 04/14/2010
Average rating: ***..
(3.43, 7 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Ivan Zoratti (SkySQL)
Average rating: ***..
(3.00, 2 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Johan Andersson (SUN MySQL), Jimmy Guerrero (Oracle-MySQL)
Average rating: ****.
(4.75, 4 ratings)
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? Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Architecture and Technology
Location: Ballroom E
Timour Katchaounov (Monty Program AB)
Average rating: ****.
(4.00, 3 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Bill Karwin (Karwin Software Solutions)
Average rating: ***..
(3.75, 4 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Don Beesing (Alion Science and Technology), John Powell (eMapSite)
Average rating: **...
(2.00, 3 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Products and Services
Location: Ballroom H
Santosh Janardhan (Facebook), Mark Konetchy (Facebook), Ryan Thiessen (Facebook)
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. Read more.

3:05pm

Add to your personal schedule
Wednesday, 04/14/2010
Replication and Scale-Out
Location: Ballroom A
Seppo Jaakola (Codership), Alexey Yurchenko (Codership)
Average rating: ***..
(3.20, 5 ratings)
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 Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Jonas Oreland (Sun Microsystems)
Average rating: *****
(5.00, 3 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Eric Day (craigslist), Giuseppe Maxia (Continuent)
Average rating: ***..
(3.86, 7 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Architecture and Technology
Location: Ballroom D
John Russell (Oracle Corporation), Calvin Sun (Twitter)
Average rating: ***..
(3.00, 1 rating)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Chris Schneider (Ning.com)
Average rating: ***..
(3.50, 4 ratings)
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! Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Harrison Fisk (Facebook)
Average rating: ****.
(4.08, 13 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Don Beesing (Alion Science and Technology), John Powell (eMapSite)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Products and Services
Location: Ballroom H
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. Read more.

4:25pm

Add to your personal schedule
Wednesday, 04/14/2010
Sheeri K. Cabral (Mozilla Foundation)
Average rating: ***..
(3.00, 1 rating)
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? Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Sarah Sproehnle (Cloudera, Inc.), Chris Schneider (Ning.com)
Average rating: ***..
(3.56, 9 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Nicklas Westerlund (Electronic Arts)
Average rating: **...
(2.50, 6 ratings)
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 Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Matt Yonkovit (Percona)
Average rating: ***..
(3.33, 6 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Peter Zaitsev (Percona Inc)
Average rating: ****.
(4.00, 9 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Dimitri KRAVTCHUK (Sun Microsystems / Oracle)
Average rating: ****.
(4.50, 2 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Architecture and Technology
Location: Ballroom G
Tobias Asplund (Marin Software), Konstantin Osipov (MySQL)
Average rating: ***..
(3.25, 4 ratings)
Two MySQL engineers who have worked on developing stored procedures or related features will walk through the whole thing. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Products and Services
Location: Ballroom H
Dustin Sallings (NorthScale), Matt Ingenthron (Couchbase, Inc.)
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. Read more.

5:15pm

Add to your personal schedule
Wednesday, 04/14/2010
.NET/Windows
Location: Ballroom A
Reggie Burnett (Oracle), Mike Frank (Gazzang, Inc.)
Average rating: *....
(1.00, 1 rating)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Roger Booth (WebAssign)
Average rating: **...
(2.00, 4 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Danil Zburivsky (The Pythian Group)
Average rating: ***..
(3.50, 4 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Sumeet Bansal (Fusion-io), Ryan White (Cloudmark), Dan Marriott (Answers.com), Vadim Tkachenko (Percona Inc), Jeremy Zawodny (craigslist.org)
Average rating: ***..
(3.17, 6 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Peter Zaitsev (Percona Inc)
Average rating: ****.
(4.33, 6 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Julian Hyde (SQLstream), Steve Herskovitz (SQLstream)
Average rating: ***..
(3.50, 2 ratings)
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 Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Architecture and Technology
Location: Ballroom G
Konstantin Osipov (MySQL), Tobias Asplund (Marin Software)
Average rating: ***..
(3.50, 2 ratings)
Two MySQL engineers who have worked on developing stored procedures or related features will walk through the whole thing. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Andrew Aksyonoff (Sphinx Technologies)
Average rating: **...
(2.67, 3 ratings)
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. Read more.

7:00pm

Add to your personal schedule
Wednesday, 04/14/2010
Location: Ballroom EFGH
Average rating: ****.
(4.67, 3 ratings)
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. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Location: Ballroom Foyer
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. Read more.

8:30pm

Add to your personal schedule
Wednesday, 04/14/2010
Location: Ballroom A
Moderated by: Alexander Barkov
This BoF session is to discuss the current state of MySQL fulltext support for Asian languages and its possible development directions. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Location: Ballroom B
Moderated by: Dr. John Busch
Average rating: *****
(5.00, 1 rating)
Over the past few years, more than a dozen open source data store projects, often referred to as “NoSQL,” have emerged to solve needs that cannot be effectively addressed with a conventional RDBMS. This session provides an overview of these NoSQL data stores, discusses the advantages and disadvantages of each, and projects the future of the NoSQL movement. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Location: Ballroom C
Moderated by: Paul Vallee
We all have the technology and knowledge to make our system highly available, but what about people as part of the mix? DBA Managers, how do you make sure your production engineering teams are highly available? Do you have a global on-call strategy? Join this BoF to discuss the best practices around high availability for structuring DBA teams and compensation. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Location: Ballroom D
Moderated by: Mike Frank
This BoF is for for DBAs interested in MySQL Backup and Recovery tools, strategies, methods, and other options. Here's a great opportunity to ask the backup team questions or provide feedback and ideas. Come meet the MySQL Backup Team of experts on InnoDB Hotbackup, mysqldump, mysqlhotcopy, replication and more. Read more.
Add to your personal schedule
Wednesday, 04/14/2010
Location: Ballroom E
Moderated by: Bryan Alsdorf
The code for MySQL is open, but the documentation, while excellent, is not. Let's fix that, and make it better. Join us in discussing the creation of a comprehensive wiki-like knowledgebase for MariaDB/MySQL. We'll talk about where we're at, what our plans are, and how you can get involved. Read more.

Thursday, 04/15/2010

8:00am

Add to your personal schedule
Thursday, 04/15/2010
Location: Bayshore
Average rating: ***..
(3.00, 1 rating)
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. Read more.

8:30am

Add to your personal schedule
Thursday, 04/15/2010
Location: Ballroom EFGH
Kaj Arnö (SkySQL Ab)
Average rating: ***..
(3.16, 19 ratings)
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? Read more.

9:15am

Add to your personal schedule
Thursday, 04/15/2010
Location: Ballroom EFGH
Jono Bacon (Canonical Ltd)
Average rating: ***..
(3.38, 16 ratings)
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. Read more.

10:00am

Add to your personal schedule
Thursday, 04/15/2010
Location: Ballroom EFGH
Average rating: ****.
(4.35, 17 ratings)
Join us as we present the best of Wednesday night's Ignite MySQL presentations. Read more.

10:50am

Add to your personal schedule
Thursday, 04/15/2010
Mark Callaghan (Facebook), Ryan Mack (Facebook), Ryan McElroy (Facebook)
Average rating: ****.
(4.06, 18 ratings)
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
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! Read more.
Add to your personal schedule
Thursday, 04/15/2010
Calvin Sun (Twitter), Jimmy Yang (Oracle Corporation), John Russell (Oracle Corporation)
Average rating: ***..
(3.00, 3 ratings)
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Peter Zaitsev (Percona Inc)
Average rating: ****.
(4.80, 5 ratings)
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Moshe Shadmon (ScaleDB)
Average rating: ***..
(3.00, 1 rating)
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Architecture and Technology, Migration
Location: Ballroom G
Ronald Bradford (EffectiveMySQL)
Average rating: *****
(5.00, 1 rating)
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Average rating: ****.
(4.25, 4 ratings)
This talk explains how TokuDB Fractal Trees work and presents both theoretical and empirical evidence of its performance advantages. Read more.

11:55am

Add to your personal schedule
Thursday, 04/15/2010
Architecture and Technology
Location: Ballroom A
Paul Vallee (Pythian)
Average rating: ***..
(3.00, 2 ratings)
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Baron Schwartz (VividCortex)
Average rating: ****.
(4.25, 4 ratings)
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Architecture and Technology
Location: Ballroom C
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Vadim Tkachenko (Percona Inc), Morgan Tocker (Percona, Inc.)
Average rating: ***..
(3.50, 4 ratings)
This session is an overview of XtraBackup, a free, open-source hot backup solution for InnoDB and XtraDB engines. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Replication and Scale-Out
Location: Ballroom E
Danil Zburivsky (The Pythian Group)
Average rating: ****.
(4.00, 3 ratings)
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Peter Zaitsev (Percona Inc)
Average rating: **...
(2.67, 3 ratings)
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Architecture and Technology
Location: Ballroom G
Average rating: **...
(2.50, 4 ratings)
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Frank Mashraqi (Opportunities)
Average rating: *....
(1.00, 2 ratings)
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. Read more.

2:00pm

Add to your personal schedule
Thursday, 04/15/2010
Sheeri K. Cabral (Mozilla Foundation)
Average rating: ***..
(3.50, 4 ratings)
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Stewart Smith (Percona)
Vapour is a server that speaks the memcached protocol and uses MySQL Cluster (NDB) as the storage backend. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Giuseppe Maxia (Continuent), Eric Day (craigslist)
Average rating: ***..
(3.50, 2 ratings)
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Ronald Bradford (EffectiveMySQL)
Average rating: ***..
(3.00, 3 ratings)
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Average rating: ****.
(4.75, 4 ratings)
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Yasufumi Kinoshita (Percona Inc.)
Average rating: ***..
(3.00, 8 ratings)
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Frank Mashraqi (Opportunities)
Average rating: *....
(1.00, 4 ratings)
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Chuck Bell (Oracle), Mats Kindahl (Oracle)
Average rating: **...
(2.00, 1 rating)
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. Read more.

2:50pm

Add to your personal schedule
Thursday, 04/15/2010
Peter Zaitsev (Percona Inc)
Average rating: ***..
(3.20, 5 ratings)
Wondering how to build a good foundation for running MySQL? This session will teach you what you need to know. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Architecture and Technology
Location: Ballroom B
Konstantin Osipov (MySQL), Peter Gulutzan (MySQL AB)
Average rating: **...
(2.00, 2 ratings)
A demo of downloadable publicly available as-of-April-2010 MySQL alphas + betas. Read more.
Add to your personal schedule
Thursday, 04/15/2010
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Aleksandr Kuzminsky (Percona Inc)
Average rating: ****.
(4.00, 3 ratings)
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Ruby and MySQL
Location: Ballroom E
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Alan Kasindorf (Six Apart)
Average rating: ***..
(3.00, 1 rating)
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
General
Location: Ballroom G
Mats Kindahl (Oracle), Lars Thalmann (Oracle)
Average rating: ***..
(3.00, 5 ratings)
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. Read more.
Add to your personal schedule
Thursday, 04/15/2010
Architecture and Technology
Location: Ballroom H
Average rating: ****.
(4.00, 2 ratings)
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. Read more.

3:50pm

Add to your personal schedule
Thursday, 04/15/2010
Location: Ballroom EFGH
Slava Akhmechet (RethinkDB), Michael Glukhovsky (RethinkDB)
Average rating: **...
(2.60, 5 ratings)
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 Read more.

4:35pm

Add to your personal schedule
Thursday, 04/15/2010
Location: Ballroom Foyer
Average rating: ***..
(3.00, 2 ratings)
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. Read more.
  • 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.