Personal schedule for Michael Jones

Download or subscribe to Michael Jones's schedule.

Keynote
Location: Ballroom E
Mark Callaghan (Facebook)
The inside story of MySQL use at Google, and how this performant database is scaled. Read more.
Architecture and Technology, Migration
Location: Ballroom C
Jeremy Zawodny (craigslist.org)
Craigslist serves millions of classifieds to millions of users around the world on a daily basis and MySQL is our database of record for all this data. But how do you efficiently design a search system to handle this volume? Read more.
Java, Performance Tuning and Benchmarks
Location: Ballroom F
Mark Matthews (Sun Microsystems)
Connector/J has a wealth of under-promoted performance features. Come to this session to learn about bulk data loading, load balancing, batch rewriting and the "reckless but really fast" options that C/J has. Read more.
Allan Packer (Sun Microsystems), Mikael Ronstrom (MySQL)
This session describes the joint Sun/MySQL performance & scalability project. We will look at the key performance issues, what has been achieved so far and share initial results. We will indicate some of what's on the roadmap for the immediate future. Wherever possible, best practices and recommendations for achieving optimal performance will be offered. Read more.
Products & Services
Location: Ballroom G
Ken Jacobs (Oracle / Innobase), Heikki Tuuri (Innobase / Oracle Corp.)
InnoDB has always had unique features to maximize performance and protect the integrity of your data. As hardware has evolved, InnoDB has been enhanced to take full advantage of modern multi-core, large memory platforms. Come learn about the special design features of InnoDB and the performance- and reliability-enhancing features recently introduced in the InnoDB Plugin. Read more.
Performance Tuning and Benchmarks
Location: Ballroom F
MC Brown (Sun Microsystems)
Query analysis can help highlight issues in the SQL in your application, but there are many ways of getting that information. Obvious choices are explain and the slow-query log, but newer solutions, such as live query monitoring, mysql proxy and DTrace provide additional benefits. Read more.
Matthew Yonkovit (MySQL), Yves Trudeau (Percona)
The InnoDB storage engine has been modified to use memcached as a level 2 cache, the InnoDB buffer pool being the level 1. Important reduction of the disk load and performance boost has been observed. This opens a new way of scaling out MySQL. Read more.
Architecture and Technology
Location: Ballroom A
Brian Aker (TangentOrg)
Ever wondered what would happen if we could rethink a decade worth of design changes? Drizzle is a fork of the MySQL server targeted at web development and cloud computing. We are looking at how to create database for modern multi-core, large memory databases that fit inside of an overall application framework. Read more.
Kevin Lewis (Sun Microsystems), Ann Harrison
The Falcon Storage Engine is designed to take advantage of multi-core computers. It is reaching GA at a time when computer performance is being increased mostly by adding more cores. Falcon's unique characteristics will be explained and contrasted with InnoDB and other MySQL storage engines. Read more.
Ruby and MySQL
Location: Ballroom E
Jon Dahl (Phronos)
How good are ORMs like ActiveRecord, DataMapper, and Sequel? We'll examine the dominant Ruby ORMs and look at the SQL they generate, MySQL gotchas, and what a developer really needs to know about SQL in the age of ActiveRecord. Read more.
Architecture and Technology
Location: Ballroom C
Antony Curtis (Blizzard Entertainment)
A tour of External Language Stored Procedures for MySQL and how they overcome the challenges involved when using MySQL's UDFs and SQL stored procedures. Read more.
Osma Ahvenlampi (Sulake)
Habbo, the world's leading virtual world for teens, has been running on MySQL ever since year 2000 and serves millions of users each month. It's global operation and continued product development depend on timely analysis of masses of data, a challenge we solved using Infobright's Brighthouse DWH engine. I'll tell you why and how we did that. Read more.
Michael McFadden (Sciencelogic.com)
Any application with frequent polling and extensive archiving needs has run into the situation of ‘too much data’. Tables become huge and unsearchable, performance goes down, and over time the cost to store this data adds up. This session covers data smoothing techniques including SQL query side solutions that reduce resolution for data archival storage for more efficient application performance. Read more.
Frank Mashraqi (NetEdge)
The combination of MySQL and Hadoop opens up new doors for innovation that weren't possible before. Hadoop allows for Massive Parallel Processing but falls short of offering the speed, features and advantages of a relational database such as MySQL. For data intensive startups with massive data processing requirements, a combination of Hadoop and MySQL may be the best solution. Read more.
Dathan Pattishall (Rockyou)
Sharding is all the rage now a days, this presentation explains in detail how Rockyou.com implements Sharding to support over 100 million users across various global social networks. More then 3.4 Billion queries per day are done on this new architecture all using mySQL as a common backend. Read more.
Sergey Petrunia (MySQL)
This is a query optimization troubleshooting roadmap, presented by one of the MySQL optimizer developers. First, we'll give an overview of available query execution strategies and how they are (or aren't) shown in the EXPLAIN output. Second, we'll show how one can find out what the optimizer got wrong. Third, we'll discuss what means one can use to make the optimizer pick the right query plan. Read more.
Vidur Apparao (LiveOps, Inc.), Stephen O'Sullivan (LiveOps, Inc.)
A case study of the evolution of MySQL usage, as a company moved from a scrappy startup - with the goals of finding a cheap, quick, and simple database solution - to a mature enterprise - with high availability and horizontal scalability as key requirements. Read more.
Mark Callaghan (Facebook)
Amazon EC2 is a new platform on which to run MySQL. This session evaluates the performance possible on the variety of hardware configurations available with EC2. Read more.
Jeff Freund (Clickability)
Building a SaaS platform requires application and infrastructure engineering that push beyond “enterprise scale” to “web scale”. MySQL and Memcached play a key role in scaling the Clickability platform. This presentation will tell the evolutionary story of the core technology components that have allowed the platform to scale from 0 to 400m pages per month, without changes to the architecture. Read more.
Don Beesing (Alion Science and Technology)
Long the domain of ArcSDE, Oracle, and other proprietary database back ends, MySQL can compete as a reliable open-source database solution in the rapidly expanding world of Web Mapping Services (WMS). This presentation will demonstrate the utility and flexibility of MySQL's geo-spatial features and how these can be combined with other technologies to publish data into open WMS standards. Read more.
Mattias Jonsson (Sun Microsystems), Mikael Ronstrom (MySQL)
Insights from the developers behind MySQL Partitioning. How is partitioning implemented, how does it work in the server and with the storage engines? What solutions can it be a part of and what problems does it introduce? We present a new partitioning type: Column list, range partitioning on any column type. And give the status of the current development. Read more.
Architecture and Technology
Location: Ballroom E
Frank Flynn (Spock Networks)
Looking at sharding your environment? This is the real-world example of sharding our databases using Spockproxy, a sharding-only version of the MySQL Proxy. Layout, sharding, and loading data; problems and limitations of working within shards; and how to get around these problems. The problems and solution we've come across are largely applicable to every kind of sharded environment. Read more.
Ben Handy (Google), Justin Tolmer (Google)
We are working on improving the performance and reliability of MySQL and InnoDB. We will describe each of the patches we have released, and how they are useful. Read more.
Ben Haley (NetQoS)
Writing a custom engine can seem intimidating and creating a generic engine can be. This presentation will show how to refine the requirements to a manageable subset. We will discuss the problem addressed, the approach chosen, storage engine design and API required to implement the design. We will talk about lessons learned implementing the storage engine to improve flexibility and performance. Read more.
Bob Burgess (Radian6 Technologies)
Recently faced with the problem of an ordinary table growing too large to back up or maintain, we designed a MySQL-Proxy-based storage cluster which seamlessly integrates with the rest of the database and offers redundancy, cluster-member failure protection, load balancing, and information lifecycle management (data age-out) capabilities. Read more.
Blythe Dunham (Spongecell)
Although the popular Ruby on Rails framework is known for its ability to quickly build web applications, getting the most favorable performance out of the standard database, MySQL, takes a little bit of effort. This session will cover simple techniques and tricks for optimizing the interaction of the Rails ActiveRecord for MySql. Read more.
Heikki Tuuri (Innobase / Oracle Corp.), Calvin Sun (Innobase/Oracle)
This presentation describes InnoDB on-disk file formats, the new file format management, as well as InnoDB source code structure. Read more.
Keynote
Location: Ballroom E
Don MacAskill (SmugMug)
A story of scaling, in today's world - using modern technologies like ZFS, OpenStorage, MySQL, and more, running one of the world's most popular photo sharing sites - SmugMug. Read more.
Eric Day (Drizzle/Gearman), Brian Aker (TangentOrg)
Come learn the fundamentals of how to leverage Gearman, the open-source, distributed job queuing system. Gearman can help in building scalable MySQL-backed applications or use through a user-defined function. Gearman’s generic design allows it to be used as a building block for a wide variety of applications, from farming out image processing to building your own Map/Reduce implementation. Read more.
MC Brown (Sun Microsystems)
You can run MySQL on a standard server, but there can be benefits to running MySQL within a virtualized environment. You can take advantage of the isolation it provides, or the performance gains possible by running multiple MySQL instances on one large server. This session will show you the benefits and potential issues of running MySQL in a virtualized environment. Read more.
Stewart Smith (Drizzle)
How does the database server use memory? Where? What are the scaling implications of how we allocate, use and free memory in the database server? Can we scale to many CPU cores effectively? Do alternate malloc libraries really help? Why? What does MySQL do? What does Drizzle do (and what have we changed?). These questions (and more) will be answered in this session. Read more.
Vadim Tkachenko (Percona Inc), Ewen Fortune (Percona)
InnoDB is well-known and popular, but naturally there's room for improvement. There are many hard-coded constants – what happens if we turn them into command-line parameters? InnoDB is also incredibly complex, with a lot going on under the covers. What algorithms can we change to make InnoDB faster and more scalable, especially on modern hardware? Read more.
Christopher Lavigne (Breadboard BI, Inc.)
Based on a real-world case study from a comprehensive market intelligence product - developed for Boats.com/YachtWorld.com by Breadboard BI, Inc - this 45 minute presentation describes a multi-source, enterprise data warehouse developed on a 100% open source stack - MySQL 5.1 (with partitioning), Pentaho Business Intelligence Suite, Linux OS. Read more.
Frank Mashraqi (NetEdge)
memcached usage is growing like wild fire and most major Web 2.0 websites depend heavily on it. In this session, we will explore several advanced memcached and MySQL use cases. Come see how some of the top destinations online are using memcached to scale their applications, offload load from databases and decrease their application response time. Read more.
Architecture and Technology
Location: Ballroom E
Heikki Tuuri (Innobase / Oracle Corp.)
This presentation describes how InnoDB manages concurrency control, so that users get superior performance and transaction throughput, while the system protects data integrity. Read more.
Keynote
Location: Ballroom E
Chuck Hagenbuch (Blue State Digital), Leigh Heyman (Blue State Digital), Stephen Gunn (Google, Inc), Mikey Dickerson (Google), Ian Gulliver (Google)
Barack Obama's presidential campaign created an unprecedented online grassroots movement in which supporters generated thousands of events, made millions of phone calls, raised record amounts of money, and received over a billion emails. Read more.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com

Download the MySQL 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

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.