MySQL Conference & Expo 2011 Schedule

Below are the confirmed and scheduled talks at MySQLConf 2011 (schedule subject to change).

Customize Your Own Schedule

Create your own MySQLConf schedule using the personal scheduler function. Mark the tutorials, 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.

We will examine the challenges faced by Zynga in running a large scale MySQL plant in EC2. Serving our social games to millions of players around the globe has required significant investment in automation and performance optimization to the thousands of MySQL instances that drive the games. Delivering high performance in the cloud requires a unique approach to support high CPU and I/O demands.

Founded by two high school students in 2005, myYearbook.com has grown to become one of the top 5 social networks and one of the top 25 most trafficked web sites in the United States. In this session, we'll review the growing pains, unique architectural decisions, and methodologies employed to support the consistent growth and demand of a social network.

2:00pm-3:00pm (1h)
Architecture and Technology, Business and Case Studies, Memcached, NoSQL, Ruby and MySQL, Storage Engine Development and Optimization

Building and Deploying Large Scale Real Time News System with MySQL and Distributed Cache

Tao Cheng (AOL)

AOL deployed its large scale Real Time News (RTN) system in 2007. This system receives news updates from over 30,000 sources on every second around the clock. Today, its data store, MySQL, has accumulated over several billions of rows and terabytes of data. However, news are delivered to end users in close to real time fashion. This presentation shares how it is done and the lessons learned.

4:25pm-5:10pm (45m)
Drizzle

Drizzle Replication Roadmap

David Shrewsbury (Rackspace)

Drizzle has thrown out the MySQL replication system and has started from scratch in implementing its own replication architecture. In this session, we'll take a look at the basics of the new architecture, what tools are available, and discuss possible future functionality. An example setup will also be presented.

Be Rich and Fast: Membase Key-Value Stores for Interactivity, MySQL for Full Queryability

Matt Ingenthron (Couchbase, Inc.)

With contemporary web applications, data is never isolated to one store. Memcached has long been a partner to MySQL; now Membase, a persistent, replicated, clustered memcached-protocol-compatible datastore is used alongside MySQL for simple, fast key-value access. This session will dispel the idea of needing to choose between SQL or NoSQL, showing how you can be both rich and fast.

10:50am-11:50am (1h)
Memcached

Gearman From A Worker's Perspective

Brian Aker (HP)

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.

11:55am-12:40pm (45m)
Security and Database Administration

Achieving PCI Compliance with MySQL

Fernando Ipar (Percona)
et al

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.

2:00pm-3:00pm (1h)
Architecture and Technology

MySQL Best Practices for DBAs and Developers - Part 1

Ronald Bradford (EffectiveMySQL)

Learn the right techniques to maximize your investment in MySQL by knowing the best practices for DBAs and Developers. Understand what subtle differences between MySQL and other RDBMS products are essential to understand in order to maximize the benefits and strengths of MySQL. We will be covering areas including the minimum MySQL configuration,ideal SQL, MySQL security and schema optimizations.

3:05pm-3:50pm (45m)
Architecture and Technology

MySQL Best Practices for DBAs and Developers - Part 2

Ronald Bradford (EffectiveMySQL)

Too much for just one session, in Part 2 we continue with learning the right techniques to maximize your investment in MySQL by knowing the best practices for DBAs and Developers. Get ahead of finding and addressing architecture and performance by doing it right the first time.

4:25pm-5:10pm (45m)
MySQL Cluster and High Availability

MySQL Cluster Architecture

Max Mether (SkySQL Ab)

Describe cluster feateres, node types, internal processes etc.

5:15pm-6:00pm (45m)
Drizzle, LAMP, Memcached

Perl programming with MySQL and Drizzle

Patrick Galbraith (Hewlett Packard)

Perl has been around for a while now. Even with buzz around other interpreted languages, Perl is still prevalently used in many applications- anything from simple database utilities, database administrative tools or web applications, it is useful to know how to program with Perl along with a relational database. This session is refresher course for lovers and non-lovers of Perl alike.

10:50am-11:50am (1h)
Performance Tuning and Benchmarking

MySQL State of the Art at Facebook

Harrison Fisk (Facebook)
et al

Running MySQL at a scale of Facebook leads to many unique problems. We will
discuss some of the performance problems seen in production systems and the tools and
techniques involved in solutions.

This talk is a guided tour of Aspersa, a toolkit that spun off from the popular Maatkit tools. It includes tools such as an I/O profiler, a bottleneck analysis tool, and tools to quickly summarize a system's configuration and status.

2:00pm-3:00pm (1h)
Security and Database Administration

openark-kit: MySQL utilities for everyday use

Shlomi Noach (openark.org)

openark-kit is a tool set of scripts which fills in some gaps in daily MySQL maintenance work. Some scripts make for automation of routine work; others introduce new functionality to the MySQL server. This session introduces concepts and usage of the openark-kit.

Small web apps running on shared hosting or single/dual server environments can take advantage of many optimizations without requiring additional hardware or drastic application redesign. This session is aimed at developers and covers the "low hanging fruit" type optimizations that just about everyone has to learn the hard way!

4:25pm-5:10pm (45m)
Business and Case Studies, Drizzle

Ubuntu and Drizzle -- Run Drizzle on your Narwhal

Clint Byrum (HP)

Ubuntu has always been focused on leadership as a development platform for Free Software. Drizzle has always been focused on being flexible and integration friendly. The Ubuntu Server Team has teamed up with the Drizzle Development team to get Drizzle working on Ubuntu, and show developers how easy it is to port their apps to use Drizzle. As of Ubuntu 11.04, Drizzle will be included in Ubuntu.

phpMyAdmin is a well-known PHP application for managing MySQL database. What's wrong with it? It is big, slow and it misses support for many advanced features like stored procedures or triggers.
Its free alternative Adminer provides user-friendly interface, requires no setup, is lightning fast and highly customizable. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL and Oracle.

10:50am-11:50am (1h)
Storage Engine Development and Optimization

Update on the PBXT Storage Engine

Paul McCullagh (PrimeBase Technologies GmbH)

Learn about the latest developments in and around the PBXT Storage Engine. Emphasis will be placed on technical aspects, discussing how things work, and giving practical examples. I will also present the latest performance results for PBXT which reveal a particular sweet spot when running a new benchmark called the “Provider Benchmark”.

11:55am-12:40pm (45m)
Architecture and Technology, PostgreSQL

Mixed MySQL/PostgreSQL Environments

Jeff Davis (Aster Data)

Mixed SQL system environments are a reality for most organizations. MySQL and PostgreSQL are a natural combination -- both are open source, and they complement each other nicely. See how to improve data consolidation, increase confidence in query results, and analyze data across applications.

OpenStreetMap raw data for any non-trivial area
comes as a massive amount of XML data.
Processing that XML data directly is possible, importing it into into a spatial database provides for much more interesting processing options though, especially when it comes to producing on demand map data for web applications with acceptable performance.

War Stories and Solutions: Operational Fun with PostgreSQL and PostGIS in the Cloud

Andy Parsons (Obikosh.com)

As CTO of Outside.in, and in my new stealth company, I've seen my share of challenging scenarios keeping a very busy PostgreSQL-based startup online and responsive during tremendous growth. EC2 + PostgreSQL + PostGIS + no downtime. Others can probably learn from my battle scars!

4:25pm-5:10pm (45m)
MySQL Cluster and High Availability

Automatic Failover: Design and Reality

Ian Gulliver (Google)
et al

Google engineers have built a system that detects MySQL master failure, chooses a new master, promotes it and hooks up slaves with under a minute downtime. This is deployed in an environment where there's zero tolerance for transaction loss of any sort. The original designer and a sysadmin who worked on the deployment will talk about design, implementation and practical lessons learned.

5:15pm-6:00pm (45m)
Performance Tuning and Benchmarking, PostgreSQL

Bottom-up Database Benchmarking

Greg Smith (2ndQuadrant US)

While databases are increasingly being distributed across multiple nodes, the performance of every node still matters--especially if you're considering virtualized or cloud deployments that have their own specific trade-offs. Memory performance scaling as core count changes, all aspects of disk performance, and using sysbench to benchmark both MySQL and PostgreSQL are all topics covered here.

10:50am-11:50am (1h)
Data Warehousing and Business Intelligence

Data Warehousing the MySQL Way: What's Hot and How It Works

Ivan Zoratti (SkySQL)

MySQL ubiquity is expanding from the online world to many other areas. Data Warehousing is one of the hottest and fast growing sectors for MySQL, due to its reduced TCO and ease of use.
In this session we will present what's new in the DW market around MySQL and how MySQL Server can be used to achieve success in Data Warehousing, Business Intelligence, OLAP and Reporting Projects.

11:55am-12:40pm (45m)
Business and Case Studies, PostgreSQL

Maintaining Terabytes: 10 Things to Watch Out For When PostgresSQL Bets Big

Selena Deckelmann (PostgreSQL)

Size can creep up on you. Some day you may wake up to a multi-terabyte Postgres system handling over 3000 tps staring you down. Learn the best ways to manage these systems as they grow, and find out what new features in 9.0 have made life easier for administrators and application developers working with big data.

2:00pm-3:00pm (1h)
Architecture and Technology, Business and Case Studies, Security and Database Administration

Preparing for the Big Oops: How to Build Disaster Recovery Sites for MySQL

Robert Hodges (Continuent.com)

Site failures can blow your business out of the water unless you have a disaster recovery site already setup, tested, and ready to go. This talk presents a cookbook approach for setting up and managing MySQL DR. Standard architectures, failover procedures, and failback are covered. Finally, we talk about how to test it all so you know it works.

Sharding is a pain. Anyone who says differently is trying to sell you something. Gwen Shapira will share stories from her 13 years of sharding experience: Learn how you can have less-painful sharded architecture using your favorite relational database.

10:50am-11:50am (1h)
MySQL Cluster and High Availability

MySQL Cluster - Real Time Performance for the Web with 5x9 Availability and Sometimes SQL

Bernhard Ocklin (Oracle Svenska AB)
et al

This session will introduce you to new MySQL Cluster features, its performance in benchmarks, and shows how major mobile phone and web companies build highly available real time solutions based on MySQL Cluster. Sometimes even with SQL.

While MySQL and MongoDB often fight over the same deployment, there are many cases where MySQL and MongoDB should be used in conjunction.
They each excel at different things, so its important to understand when to use one or the other, and how to make them work well together.
Eliot Horowitz is the CTO and Co-Founder of 10gen, the creators of MongoDB

3:05pm-3:50pm (45m)
Architecture and Technology, MySQL Cluster and High Availability, Replication and Scale-Out

Gizzard: A Pragmatic Distributed Storage Framework

Matt Freels (Twitter)

At Twitter, we have gone through many iterations of storage systems as we have coped with tremendous growth. We have been able to solve many general distributed storage problems in a framework named Gizzard. This has allowed us to quickly and safely develop specialized components for the parts of Twitter that can no longer handle the scale at which they are required to operate.

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

NoSQL with MySQL

Yekesa Kosuru (Nokia)
et al

The “NoSQL” movement is typically related to key-value systems and, lacking a formal definition, can be interpreted many ways. NoSQL discussions that focus on availability and scalability highlight ACID issues but not really SQL.
The key-value systems can be built many ways and relational databases as a back end is a serious contender.

Most of high scale web applications use memcached + MySQL or NoSQL. It is said that NoSQL performs better than MySQL for simple access patterns such as primary key lookups. But things are changing. DeNA recently developed HandlerSocket plugin, a MySQL plugin speaking NoSQL protocols. We got 750,000+ qps in our benchmarks and runs pretty well on our production. We'd like to share our experiences.

10:50am-11:50am (1h)
Products and Services

Replication for Availability & Durability with MySQL and Amazon RDS

Grant McAlister (Amazon.com)

Whether running with commodity servers on premise or in the cloud, there are many failure scenarios to protect your database against. In this session we will walk through the different types of replication possible with both self-managed MySQL deployments and managed Amazon Relational Database Service cloud deployments, understanding how they can help improve your availability and durability.

If you thought running a database in the cloud was easy, think again. Databases in a cloud environment are inherently different from traditional installations in a datacenter or even in your trusted hosted environment. Today I'll explain the four key considerations we believe every system architect should take into account when designing their database for the cloud.

3:05pm-3:50pm (45m)

Dynamic Columns

Michael Widenius (Monty Program Ab)
et al

New feature of Maria DB which makes schema-less part of table possible will be described for database users with some details of its implementation on the server.

4:25pm-5:10pm (45m)
Security and Database Administration

Percona Server and XtraBackup: painless operations

Vadim Tkachenko (Percona Inc)

This talk shows how to use Percona Server together with XtraBackup to make important operational tasks easy.

The next major release of Memcached, memcached 1.6, will support loadable storage engines to manage cached data. The NDB Engine for Memcached allows MySQL Cluster and Memcached to be used together in a wide variety of ways, and can be individually configured for particular memcached key prefixes. The presentation will include an overview, how-tos, and benchmarks.

10:50am-11:50am (1h)

Session

To be confirmed

11:55am-12:40pm (45m)
Products and Services

SkySQL's Reference Architecture Partner Panel Discussion

Kaj Arnö (SkySQL Ab)

Kaj Arnö, executive vice president of products for SkySQL will lead a panel of strategic partners including Calpont, Linbit, ScaleDB, Webyog and Zimory in a discussion of the SkySQL Reference Architecture for deploying data infrastructure solutions for the MySQL® database.
Wednesday, April 13, 11:55 a.m.
Ballroom H

2:00pm-3:00pm (1h)
Architecture and Technology

Group Commit and Related Enhancements to the MariaDB Binary Log

Michael Widenius (Monty Program Ab)
et al

Group commit is a very important optimisation for ACID storage engines in high transaction-per-second OLTP that is implemented for the binlog in MariaDB. Usage, benchmarks, and technical details of the implementation are presented, as well as the underlying extension to the storage engine API that enables better provisioning of replication slaves from non-blocking backup, and other enhancements

3:05pm-3:50pm (45m)
Cloud Computing, NoSQL, Replication and Scale-Out

Redis to the Rescue?

Tim Lossen (wooga - world of gaming)

As an in-memory database, Redis offers an order-of-magnitude
reduction in query roundtrip latency, but also introduces new
challenges. This case study recounts how we successfully scaled
up two Facebook games with Redis, and what we learned on the way.

4:25pm-5:10pm (45m)
Architecture and Technology, Business and Case Studies, PostgreSQL

Own it: Working with a changing open source database community

Selena Deckelmann (PostgreSQL)

Taking lessons from the PostgreSQL community, and recent experience with the growing communities around the forks of MySQL, this talk will lead business owners, project managers and developers through best practices for connecting to and being successful working with open source database developers.

5:15pm-6:00pm (45m)
Architecture and Technology, Business and Case Studies, LAMP, MySQL Cluster and High Availability, Replication and Scale-Out

Delivering Scalable and Highly Available Session Management with MySQL Cluster

Mat Keep (MySQL)
et al

Discover how MySQL Cluster can be used to store session data for the new generation of web applications that demand persistence, massive scalability and high levels of availability. We'll cover what today's applications need from a session store; why MySQL Cluster is so suited to meeting those needs and how to implement them. To make this more real we'll present some real life case studies.

9:00am-9:30am (30m)
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. MariaDB is now 2 years old, and has made 2 releases in 2010. He’ll also present an overview of the future of this community developed branch of the MySQL database.

9:30am-10:00am (30m)
Keynote

Data in the Cloud

Mårten Mickos (Eucalyptus Systems)

Elasticity is a key characteristic of public, private and hybrid clouds. Virtual machines can be spun up and spun down at a moment's notice. But how do databases behave in clouds?

10:00am-10:20am (20m)
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.

7:00pm-8:30pm (1h 30m)

Ignite MySQLconf

Brian Aker (HP)

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’ll find out this year at Ignite MySQLconf.
Ignite MySQLconf will happen on Wednesday, April 13 at 7:00pm.
The call for Ignite MySQLconf talk proposals now closed.

10:00am-2:00pm (4h)
Event

MySQL Career Zone

Join participating sponsors and other companies as they present open positions from their respective companies. Wednesday, April 13th, 10:00am – 2:00pm.

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

Break: Morning Break

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

Break: Afternoon Break - Sponsored by Xeround

6:00pm-7:00pm (1h)

Wednesday Night BoFs

Birds of a Feather (BoF) sessions provide face to face exposure to those interested in the same projects and concepts. BoFs are happening at MySQL Conference & Expo Tuesday from 7:00p - 11:00pm and Wednesday from 6:00p - 11:00p.