Choosing right Hardware components, configuring them properly, and optimizing Linux settings are very important for MySQL and other database server deployments. But they are frequently overlooked. Learning best practices will certainly improve performance and stability. Do you want to learn these best practices? This three-hour tutorial is for you.
Read more.

This talk is about Innodb and XtraDB architecture with focus on architecture aspects important for performance optimization. We will also look into tuning Innodb settings as well as designing database schema and application to take advantage of architecture.
Read more.

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.
Read more.

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.
Read more.

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.
Read more.

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.
Read more.

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.
Read more.

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.
Read more.

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.
Read more.

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.
Read more.

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.
Read more.

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.
Read more.

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.
Read more.

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.
Read more.

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.
Read more.

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.
Read more.

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.
Read more.

Transactional databases almost always use checkpointing, and checkpointing is really, really hard to do well. From Postgres to InnoDB to PBXT, the dreaded "checkpoint spike" has caused or continues to cause server stalls. Come learn how different databases do checkpoints and how to tune yours properly.
Read more.

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.
Read more.

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.
Read more.

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.
Read more.

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.

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.
Read more.

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.
Read more.

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.
Read more.

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.
Read more.

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!
Read more.

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.
Read more.

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.
Read more.

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.
Read more.

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.
Read more.

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.
Read more.

Xtrabackup Manager is a new tool for scheduling your MySQL backups. It
uses Xtrabackup from Percona as the backup tool - in the future we
will support also other tools like mysqldump. This is a new project,
rough around the edges and incomplete user interface, but it can
already take a backup. If you are interested in working on the code
with us, even better!
Read more.

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.
Read more.

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.
Read more.

InnoDB becomes the default storage engine in MySQL 5.5. At this session, you will learn the current state of InnoDB and the latest enhancements to the InnoDB storage engine in MySQL 5.5; plus how InnoDB works.
Read more.

This presentation provides architectural guidance, design patterns, and specific suggestions for deploying and administering Data Warehouses using Mysql. It is based on lessons learned building and operating a Multi-Terabyte Mysql 5 Data warehouse over a period of 5 years.
Read more.

This talk shows you how to gather the correct data for performance forecasting and capacity planning. You will learn how to apply mathematical models to the data, and get meaningful answers that are likely to resemble reality.
Read more.

MySQL replication has been a critical part of scaling Facebook's storage infrastructure. However, it brings with it the fear of divergent replicas. This session discusses a new tool that detects divergences, identifies inconsistent data, and helps repairs defects.
Read more.

This talk will cover forecasting and planning future growth for high volume mysql instances occupying many (500+) servers. Will include metrics tracked (and how to filter through noise), when and how to migrate, operational optimizations such as upgrades that can be incorporated, and how to deal with server technology that evolves faster than server lifetimes
Read more.

Join us in Exhibit Hall A immediately following the general sessions to celebrate four fantastic days of MySQL Conference & Expo. Take the opportunity to network one last time at this closing event, enjoy some ice cream and other tasty refreshments.
Read more.

Diamond Sponsor

Gold Sponsors

Sponsorship Opportunities

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