MySQL Conference & Expo 2010 Speaker Slides & Video

Presentation slides will be made available after the session has concluded and the speaker has given us the files. Check back if you don't see the file you're looking for—it might be available later! (However, please note some speakers choose not to share their presentations.)

Johan Andersson (SUN MySQL), Jimmy Guerrero (Oracle-MySQL)
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?
Tod Landis (dbEntrance Software)
Details coming soon!
Gerardo Narvaja (SkySQL Inc.)
Present what I believe are fundamental laws taken from other disciplines that should be applied while looking into DB (or any other system) diagnosis: * Derivates: rate of change * Heisenberg's Uncertainty principle: Observer effect * Nyquist Sampling
Mark Callaghan (Facebook)
MySQL has been the incumbent for high-scale applications. Times change. How do we adapt to remain relevant?
Brian Aker (HP)
A guide for the SQL world for nosql.
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.
Julian Hyde (SQLstream), Steve Herskovitz (SQLstream)
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
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.
Vadim Tkachenko (Percona Inc), Morgan Tocker (Percona, Inc.)
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.
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.
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.
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.
Sarah Novotny (NGINX)
Backups aren't exciting or glamorous. They don't make you money and there's no such thing as a valid backup. But, understanding your restores is exciting! Let me draw you a few pictures of database restores at their most ironic, entertaining, and even thrilling.
Join us as we present the best of Wednesday night's Ignite MySQL presentations.
Robert Hamel (Pythian)
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
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.
Robin Schumacher (Calpont)
Details coming soon.
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.
Peter Zaitsev (Percona Inc)
Wondering how to build a good foundation for running MySQL? This session will teach you what you need to know.
Matt Yonkovit (Percona)
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.
Robert Hodges (Continuent.com)
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!
Geert Vanderkelen (Sun Microsystems)
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).
Danil Zburivsky (The Pythian Group)
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.
Baron Schwartz (VividCortex Inc), Morgan Tocker (Percona, Inc.)
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.
Bernhard Ocklin (Sun Microsystems AB), Andrew Morgan (Oracle)
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
Baron Schwartz (VividCortex Inc)
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.
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!
Sheeri K. Cabral (Mozilla Foundation)
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.
Seppo Jaakola (Codership), Alexey Yurchenko (Codership)
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
Sarah Sproehnle (Cloudera, Inc.), Chris Schneider (Ning.com)
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.
Giuseppe Maxia (Continuent), Eric Day (craigslist)
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.
Mark Atwood (HP Cloud Services)
A humorous counterpoint to Brian Aker's humorous send up of NoSQL.
Domas Mituzas (Facebook)
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.
David Berube (Berube Consulting)
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.
Peter Zaitsev (Percona Inc)
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.
Yasufumi Kinoshita (Percona Inc.)
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.
This talk explains how TokuDB Fractal Trees work and presents both theoretical and empirical evidence of its performance advantages.
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.
Peter Zaitsev (Percona Inc)
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.
Peter Zaitsev (Percona Inc)
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.
Calvin Sun (Twitter), Jimmy Yang (Oracle Corporation), John Russell (Oracle Corporation)
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.
Peter Zaitsev (Percona Inc)
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.
Jimmy Yang (Oracle Corporation)
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.
Chuck Bell (Oracle), Mats Kindahl (Oracle)
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.
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.
Presentation: external link
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.
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.

Presentation

Michael Widenius (Monty Program Ab)
MariaDB, where we are at, and where we are going. The short version.
Kurt von Finck (Monty Program Ab)
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!
Harrison Fisk (Facebook)
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.
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.
Dimitri KRAVTCHUK (Sun Microsystems / Oracle)
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.
Padraig O'Sullivan (Akiban Technologies Inc.)
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.
Presentation: external link
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 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.
Mark Callaghan (Facebook)
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.
Johan Andersson (SUN MySQL), Joffrey Michaie (SkySQL Ab)
Getting the most out of your MySQL Cluster (NDB) deployment
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.
Andrew Morgan (Oracle), Geert Vanderkelen (Sun Microsystems), Andrew Hutchings (Hewlett-Packard)
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.
Geert Vanderkelen (Sun Microsystems)
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).
Sheeri K. Cabral (Mozilla Foundation)
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.
Sheeri K. Cabral (Mozilla Foundation)
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.
Kai Voigt (Sun Microsystems)
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.
Kai Voigt (Sun Microsystems)
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.
Arjen Lentz (Open Query), Walter Heck (Open Query)
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.
Baron Schwartz (VividCortex Inc)
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.
Grant McAlister (Amazon.com)
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.
Sergei Golubchik (MariaDB)
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.
Jan Kneschke (MySQL)
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.
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.
Sheeri K. Cabral (Mozilla Foundation)
This ignite talk will go through how the the modified mysqltuner works including how easy it is to change what is checked and the thresholds.
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.
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.
Mats Kindahl (Oracle), Lars Thalmann (Oracle)
In this talk, the developers behind MySQL Replication walk through some of the new Replication features of MySQL 5.5
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.
Alex Esterkin (Open Source Community)
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.
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.
Tim O'Reilly (O'Reilly Media, Inc.)
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.
Roland Bouman (XCDSQL Solutions / Strukton Rail)
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.
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.
Bill Schuler (Percona, Inc.), Baron Schwartz (VividCortex Inc)
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.
Peter Gulutzan (MySQL AB)
Presentation: Performance Schema Presentation [ODP]
Performance Schema is a major new MySQL Server feature which shows where we're going with monitoring and performance measurement.
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.
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!
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.
Baron Schwartz (VividCortex Inc)
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.
Aleksandr Kuzminsky (Percona Inc)
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.
Slava Akhmechet (RethinkDB), Michael Glukhovsky (RethinkDB)
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
Ben Black (Garmin), Mark Filipi (Garmin International)
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.
Mark Matthews (Oracle), Todd Farmer (Oracle Corporation)
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.
Moshe Shadmon (ScaleDB)
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.
Darren Cassar (Trading Screen Inc)
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.
Danil Zburivsky (The Pythian Group)
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.
Giuseppe Maxia (Continuent), Kentoku SHIBA (WildGrowth)
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.
Giuseppe Maxia (Continuent)
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.
Bill Karwin (Karwin Software Solutions)
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.
Presentation: external link
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.
Brian Aker (HP)
Presentation: State of Drizzle Presentation [PPT]
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.
Michael Widenius (Monty Program Ab)
Presentation: State of MariaDB Presentation [PDF]
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.
Edward Screven (Oracle Corporation)
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.
Kaj Arnö (SkySQL Ab)
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?
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.
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.
Jono Bacon (Canonical Ltd)
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.
Matt Yonkovit (Percona)
Presentation: The Five Minute DBA Presentation [PDF]
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?
Gillian Gunson (Disney Online Studios)
Mark Atwood told me he would drown my cat if I didn't give a Ignite talk, so here it is. He said it had to be something interesting and non-technical, so I thought I could talk about my personal DBA rulebook that I've been compiling for months. It's mostly a common-sense list of 10 or so do's and don'ts of being a DBA that I've realized over the years.
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.
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.

Presentation

Sheeri K. Cabral (Mozilla Foundation)
Presentation: Time Zones and MySQL Presentation [PDF]
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?
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".
Morgan Tocker (Percona, Inc.)
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.
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.
Giuseppe Maxia (Continuent)
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.
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.
Henrik Ingo (10gen), 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.
Sarah Sproehnle (Cloudera, Inc.)
Presentation: Want Faster Queries_ Presentation [PPT]
This talk is for developers or administrators who need to make their queries faster.
Bradley found SSD performance to be a little bit strange and unpredictable.
Baron Schwartz (VividCortex Inc)
A frequently asked question is "can you explain what's different between XtraDB and [MySQL, MariaDB, InnoDB, OurDelta]?" This talk explains. No brain cells will be harmed by listening to this talk.
Rob Young (Oracle/MySQL ), Mikael Ronstrom (MySQL)
Join the MySQL and InnoDB Engineering teams as they describe the low-level technical details behind the MySQL 5.5 performance and scalability gains.
Mikael Ronstrom (MySQL)
Join the MySQL and InnoDB Engineering teams to examine the eye popping MySQL 5.5 performance and scalability benchmarks.
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.
Vadim Tkachenko (Percona Inc), Morgan Tocker (Percona, Inc.)
This session is an overview of XtraBackup, a free, open-source hot backup solution for InnoDB and XtraDB engines.
  • 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.