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 next to each listing. Then click on "personal schedule" below and get your own customized schedule generated.

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.

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.

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), Mike Frank (Gazzang, Inc.)

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)
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.

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.

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 (Pythian)

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, Storage Engine Development and Optimization

Partitioning Under the Hood in MySQL 5.5

Mattias Jonsson (Sun Microsystems), Mikael Ronstrom (MySQL)

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.

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.

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.

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.

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), Calvin Sun (Twitter)

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.

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.

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.

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)

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!

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.

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)
Products and Services

Answers to the Scaling Challenge: A Case Study With Answers.com on Scaling With Memcached and MySQL

Joaquin Ruiz (Gear6), Dan Marriott (Ex Libris / ProQuest)

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.

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.

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), 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.

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.

10:50am-11:50am (1h)
Replication and Scale-Out

Mysteries of the Binary Log

Chuck Bell (Oracle), Lars Thalmann (Oracle), Mats Kindahl (Oracle)

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.

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.

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.

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.

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), 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.

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), 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.

4:25pm-5:10pm (45m)
Architecture and Technology

Stored Procedures - Part 1

Tobias Asplund (Marin Software), Konstantin Osipov (MySQL)

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), Tobias Asplund (Marin Software)

Two MySQL engineers who have worked on developing stored procedures or related features will walk through the whole thing.

8:00am-6:00pm (10h)

Open Space for MySQL Participants

Open Space for MySQL Participants 2010, a community organized event designed to share and improve the essential skills required to participate in collaborative, free and open online projects. The event features a mix of educational presentations and hands-on coaching from experts in participatory communities. MySQL Open Space attendance is free with an Expo Hall pass.

8:30am-9:15am (45m)
Keynote

State of 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.

10:20am-10:50am (30m)

Break: Morning Break: Located in Expo Hall

3:50pm-4:25pm (35m)

Break: Afternoon Break: Located in Expo Hall

10:00am-5:00pm (7h)

Career Zone

Join participating sponsors, exhibitors, and Nelson Staffing agency as they present open positions from their respective companies.

7:00pm-10:00pm (3h)

Birds of a Feather Networking Sessions

Birds of a Feather (BoF) sessions provide face-to-face exposure to those interested in the same projects and concepts. BoFs can be organized for individual projects or broader topics (best practices, open data, standards). BoFs are entirely up to you. We post your topic online and onsite and provide the space and time. You provide the engaging topic.

12:40pm-2:00pm (1h 20m)

Break: Lunch

Founding Sponsor

Platinum Sponsor

Gold Sponsors

Joint Gold Sponsors

Premier Media Partner

Sponsorship Opportunities

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