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.

This talk will discuss the ongoing evolution of data storage at Craigslist, starting from a homogeneous one-size fits all "MySQL everywhere" approach and moving toward a heterogeneous environment that considers our real data and performance needs and the plethora of tools available today (including Redis, MongoDB, MySQL, and Sphinx).

In the midst of many attempts to "solve" the RDBMS high availability problems, the vast majority of Yahoo sites are still using plain old boring MySQL replication to accomplish HA. This talk will cover the principles of this architecture, it's advantages and disadvantages, as well what we see as needed for future HA advances. It's old-school, it's crude, but somehow it solves most HA problems.

Complex normalized schemas can make database systems slow and inefficient. This presentation explores a storage layer that eliminates most joins in such systems by pre-joining the data. Data in this storage layer can be accessed using an object API without the overhead of an object-relational mapping layer. It can also be accessed using standard SQL for efficient complex multi-table reporting.

3:05pm-3:50pm (45m)
Performance Tuning and Benchmarking

Performance Best Practices for MySQL

Peter Zaitsev (Percona LLC)

It takes a lot to deliver consistent high performance for your MySQL powered system. In this presentation we'll look at defining Performance Goals, understanding Architecture Scalability and performing Capacity Planing.

4:25pm-5:10pm (45m)
Cloud Computing

Granular Archival and Nearline Storage Using MySQL, S3 and SQS

Walt Jones (SEOmoz)

Moving rarely accessed data out of your main database can have a big impact on speed and cost. This session covers techniques to analyze the granularity of your data and implement an archival strategy that allows you to recall archived data on demand.

5:15pm-6:00pm (45m)
Data Warehousing and Business Intelligence

Open Source reporting tools

David Stokes (Oracle)

Need quick ad-hoc reports with sharp graphics from you MySQL instances? There are several open source reporting tools from Penatho, Actuate, Jaspersoft and others that can make a DBAs lies much easier. This session covers the more popular reporting tools and reommendations for for their use in your environment.

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

MySQL Replication Update

Lars Thalmann (Oracle), Alex Roedling (Oracle)

The developers behind MySQL Replication describe the new features. After a quick review of what MySQL 5.5 brings, focus turns to the features that are coming after MySQL 5.5.

11:55am-12:40pm (45m)
Architecture and Technology, MySQL Cluster and High Availability, Replication and Scale-Out

The Art of Sandboxing - Reducing Complex Systems to Manageable Boxes

Giuseppe Maxia (Continuent)

Database technology is seldom simple. Unless you are dealing with an embedded, self containing database such as SQLite, chances are that your data management requires a complex system involving one or more database servers. Whether you need to test new systems or benchmark existing scenarios, your common need is to isolate the system. This talk tells how to tame database systems into obedience.

In this session, I will talk about tough DBA tasks - how to automate failover under non-trivial crash situations (i.e. promoting one of slaves to new master), and about how to eliminate downtime for difficult maintenance tasks (i.e sharding). If you have spent too much time for these tasks, this session will help your DBA life easier.

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

Detecting Data Drift In a Live System

Mikey Dickerson (Federal Government | United States Digital Services Team)

Google engineers talk about the long fight against the specter of data drift. Starting from historical FUD about data drift, Google SREs will discuss design and implementation of a solution to detect data drift on any slave without downtime, and lessons learned from deployment and running in a world with detection.

Are you considering how to use SSD disks with MySQL? Should you even use them? Will they make your database faster? They are still expensive, so how can you get the most out of them? This is the talk for you

Apache Hadoop is a distributed, batch-processing system for large data sets. It can be used alongside relational databases to enable more effective reporting and injestion of large amounts of raw or unstructured data.

11:55am-12:40pm (45m)
Performance Tuning and Benchmarking

Understanding Indexing

Zardosht Kasheff (Tokutek)

We present some simple rules to understand effective indexing techniques without requiring an understanding of the underlying data structures that store the data.

Production schema changes are painful but unavoidable. This session will tell you how to
minimize (or totally eliminate) downtime during schema changes with master-master setup or by using "shadow" tables.
Session will focus on pros and cons of each approach and describe most common use cases.

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

Advanced Replication Monitoring

Gerardo Narvaja (MariaDB Corp.)

Traditionally replication has been monitored using the information in SHOW SLAVE STATUS, however it doesn't always represent the full picture. This presentation will outline how combining different methodologies it is possible to obtain a more accurate picture about replication health.

4:25pm-5:10pm (45m)
Performance Tuning and Benchmarking

MySQL and Linux Tuning - Better Together

Steve Francis (LogicMonitor)

This talk will cover some of the less common linux tuning options, and how they can benefit MySQL performance, and benchmark results showing real impacts (or lack thereof) of tuning.

5:15pm-6:00pm (45m)
Security and Database Administration

Securich

Darren Cassar (MySQLPreacher)

Security is often considered a waste of time given its tedious, painful and underestimated. This is where securich comes to the rescue helping you control users, privileges and enforce good passwords. User cloning, renaming, password complexity and much much more.

Has your database grown to hundreds of gigabytes in size, with no limit in sight? Are you considering moving to an expensive proprietary database system do deal with your huge database? PostgreSQL is an excellent database for small to medium sized data warehouses in the 0.5 to 5 terabyte range.

2:00pm-3:00pm (1h)
Architecture and Technology, Storage Engine Development and Optimization

HailDB: A NoSQL API Direct to InnoDB

Stewart Smith (Percona)

HailDB is a project that maintains InnoDB as a shared library (forked from embedded_innodb). It provides an API direct to InnoDB without any pesky SQL in front of it. This session is an introduction to HailDB, followed by an introduction to programming it.

Percona Server is most known for its performance and slow-log diagnostics, but it has many other useful features. In this talk I will describe them.

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

Securing MySQL with a Focus on SSL

Chris Conlon (yaSSL)

Security is becoming more important than ever, and as such, it should be a high concern for MySQL users. In this session we will cover important MySQL security practices, with a focus on configuring and using SSL with MySQL. Although sometimes overlooked, data in transit is vulnerable and should be secured. The use of SSL/TLS provides us with a tool to help protect peace of mind and data security.

MQL-to-SQL is open source software that lets you query a RDBMS over HTTP using MQL (Metaweb Query Language). MQL is the native query language of www.freebase.com. There are good reasons to want MQL also as RDBMS query language, instead of SQL. This talk explains what MQL is, how it compares to SQL, why MQL is great for AJAX apps, and how MQL-to-SQL allows you to query RDBMSes like MySQL & Postgres

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

Using MySQL 5.5 Performance Schema

Peter Zaitsev (Percona LLC)

MySQL Performance Schema is a new performance analyzes tool in MySQL 5.5, learn how to use it for Performance Optimization tasks.

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

The Secret Sauce of Sharding

Ryan Thiessen (Facebook)

Getting sharding right is crucial for achieving high scale with MySQL on commodity hardware like we do at Facebook. We will overview sharding best practices, and show some examples of both successful and unsuccessful methods at sharding MySQL.

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

An Introduction to PostGIS - the PostgreSQL spatial extension

Ragi Burhum (Burhum LLC - GIS Consulting)

PostGIS is an extension to the PostgreSQL object-relational database system which allows GIS (Geographic Information Systems) objects to be stored in the database. It includes support for spatial indexes, and functions for analysis and processing of GIS objects.

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

Securing PostgreSQL From External Attack

Bruce Momjian (EnterpriseDB)

This talk explores the ways attackers with no authorized database access
can steal Postgres passwords, see database queries and results, and even
intercept database sessions and return false data. Postgres supports
features to eliminate all of these threats, but administrators must
understand the attack vulnerabilities to protect against them.

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

Introduction to HBase

Tom Hanlon (Functional Media)

HBase is an open source column store built on top of Hadoop.
In this 45 minute session you will get a brief introduction into the design of HBase, and the underlying framework along with some usage examples.

5:15pm-6:00pm (45m)
PostgreSQL

Introduction to PostgreSQL Configuration

Robert Haas (EnterpriseDB)

PostgreSQL is highly customizable, but which settings are most important and what values are most appropriate for a typical installation? This talk will explain the basics of how to configure PostgreSQL for reliability and good performance.

Does it really work well to have large amount of data on Amazon EC2? Yes it does, but it does require some careful thinking and testing. EC2 is not like your standard Linux box when in terms of cabability of sustaining a high load and large amounts of data. But it can sure be done, but in a different way. This talk is about what Recorded Future has experienced when working with EC2.

11:55am-12:40pm (45m)
Drizzle

A Beginner's Guide to Drizzle

Andrew Hutchings (Hewlett-Packard)

Drizzle was originally forked from MySQL in 2008 and has since gone through many changes. It is now very different from its MySQL cousin, so this talk is aimed to help anyone new to Drizzle get to grips with it from both a DBA and an application developer point of view.

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

A Beginner's Guide to MariaDB

Colin Charles (Percona)

MariaDB - Community Developed. Feature Enhanced. Backward Compatible. A branch of the popular MySQL database, the project began in 2009 around a storage engine, but quickly evolved to being another database project, with two major releases in 2010. This session will introduce the project, and will help any DBA or developer get to grips with MariaDB.

Eucalpytus is a GPL open-source private cloud computing infrastructure platform that is compatible with Amazon Web Services. It has an undeserved reputation as being hard to provision, install, and operate. We hope to help dispel this reputation by walking through and talking through installation and operation of a small Eucalyptus cloud.

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

Introduction to OpenStack

Eric Day (craigslist)

The OpenStack project was launched last summer by Rackspace, NASA, and a number of other cloud technology leaders in an effort to build a fully-open cloud computing platform. It is a collection of scalable, secure, standards-based projects currently consisting of OpenStack Compute and OpenStack Object Storage. This session will introduce the projects, principles behind it, and how to get started.

5:15pm-6:00pm (45m)
NoSQL

Building Your First Web Application with MongoDB

Roger Bodamer (10gen)

MongoDB -- from "humongous" -- is an open source, non-relational, document-oriented database.

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

Session

To be confirmed

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

Why Are The New Optimizer Features Important and How Can I Benefit From Them?

Sergey Petrunya (Monty Program Ab), Igor Babaev (Monty Program)

MariaDB has a lot of improvements to the core optimiser that powers both MySQL & MariaDB. These optimiser features all have flags which you can enable (they are disabled by default). Igor and Sergey both work on all these optimiser features on a daily basis, and will be able to go deep in-depth to explain them and why they are beneficial to end-users in general.

2:00pm-3:00pm (1h)
Products and Services

A Tour of PostgreSQL for Developers

Robin Schumacher (EnterpriseDB), Bruce Momjian (EnterpriseDB)

PostgreSQL has much to offer today’s developers who has been charged with creating applications for Web, embedded, data warehousing, OLTP, geo-spatial, and other environments. Developers will find many flexible options at their disposal with PostgreSQL no matter what language or IDE they choose to use.

3:05pm-3:50pm (45m)
Products and Services

Dropping ACID: Eating Data In A Web 2.0 World

Stewart Smith (Percona)

Those who cannot remember the past are condemned to repeat it. This is part survey, part critique of the various Atomicity, Consistency, Isolation and Durability models available from various modern databases and data stores used in modern Web and Cloud environments. We'll not just look at the single machine solution but how these systems work in a distributed environment.

A Ridiculously Easy & Seriously Powerful Cloud Database - See it in Action!

Itamar Haber (Xeround)

mysql> EXPLAIN SELECT * FROM CLOUDSQLDB
WHERE Availability=’always’
AND Scale=’auto’
AND COUNT (CloudProviders)>1;
Come see a live demonstration of a highly-available and scalable cloud database – with self-healing, auto-scaling and pay-per-use – all with a click of a button.

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

Session

To be confirmed

5:15pm-6:00pm (45m)

Session

To be confirmed

9:00am-9:40am (40m)
Keynote

State of the Dolphin

Tomas Ulin (Oracle), Duleepa Wijayawardhana (Empire Avenue)

Join Tomas Ulin, Oracle’s Vice President of MySQL Engineering, as he summarizes MySQL’s first year under Oracle’s stewardship, discusses the current and ongoing engagement with the MySQL user community and offers insights into future roadmaps and commitment to MySQL products.

9:40am-10:00am (20m)
Keynote

The State of the Elephant

Ed Boyajian (EnterpriseDB), Bruce Momjian (EnterpriseDB)

In the State of the Elephant keynote, Ed Boyajian, CEO of EnterpriseDB, and Bruce Momjian, Co-Founder of The Global PostgreSQL Development Group, will present an overview of the PostgreSQL Community.

10:00am-10:20am (20m)

2011 MySQL Awards

David Axmark (Me, MySelf and I), Michael Widenius (Monty Program Ab)

Join us for the annual MySQL Awards, as we recognize excellence in Community Contributor, MySQL Application, and Corporate Contributor categories.

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

Break: Morning Break

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

Break: Afternoon Break

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

Expo Hall Reception

Visit the exhibitors, mingle with other attendees, and enjoy great refreshments and drinks at the evening reception.

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

Break: Lunch

7:00pm-11:00pm (4h)

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

7:00pm-9:00pm (2h)
Event

MySQL Conference & Expo Meetup

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 at this year's MySQL CE Meetup.

Diamond Sponsor

Gold Sponsors

Sponsorship Opportunities

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