Personal schedule for Mike Pattison

Download or subscribe to Mike Pattison's schedule.

Replication and Scale-Out, Tutorial
Location: Ballroom E
Mats Kindahl (Oracle), Lars Thalmann (Oracle)
Average rating: ****.
(4.14, 7 ratings)
Although MySQL Replication is easy to set up and easy to configure, it is nevertheless a very versatile tool that can be used to solve many problems in modern applications. Read more.
Giuseppe Maxia (Continuent)
Average rating: ****.
(4.17, 6 ratings)
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. Read more.
Giuseppe Maxia (Continuent)
Average rating: ****.
(4.29, 7 ratings)
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. Read more.
Peter Zaitsev (Percona Inc)
Average rating: ***..
(3.07, 14 ratings)
Scaling Applications with Caching, Sharding and Replication Read more.
Replication and Scale-Out
Location: Ballroom B
Domas Mituzas (Facebook)
Average rating: ****.
(4.23, 22 ratings)
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. Read more.
Giuseppe Maxia (Continuent), Kentoku SHIBA (WildGrowth)
Average rating: ***..
(3.44, 9 ratings)
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. Read more.
Migration
Location: Ballroom B
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. Read more.
Migration
Location: Ballroom D
Average rating: **...
(2.00, 3 ratings)
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. Read more.
Matt Yonkovit (Percona)
Average rating: ****.
(4.57, 7 ratings)
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? Read more.
Ben Black (Garmin), Mark Filipi (Garmin International)
Average rating: ***..
(3.00, 3 ratings)
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. Read more.
Darren Cassar (Trading Screen Inc)
Average rating: ***..
(3.50, 4 ratings)
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. Read more.
Morgan Tocker (Percona, Inc.)
Average rating: ****.
(4.38, 8 ratings)
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. Read more.
Average rating: ***..
(3.43, 7 ratings)
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. Read more.
Replication and Scale-Out
Location: Ballroom A
Seppo Jaakola (Codership), Alexey Yurchenko (Codership)
Average rating: ***..
(3.20, 5 ratings)
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 Read more.
Architecture and Technology
Location: Ballroom G
Tobias Asplund (Marin Software), Konstantin Osipov (MySQL)
Average rating: ***..
(3.25, 4 ratings)
Two MySQL engineers who have worked on developing stored procedures or related features will walk through the whole thing. Read more.
Sumeet Bansal (Fusion-io), Ryan White (Cloudmark), Dan Marriott (Answers.com), Vadim Tkachenko (Percona Inc), Jeremy Zawodny (craigslist.org)
Average rating: ***..
(3.17, 6 ratings)
This panel discussion, moderated by Sumeet Bansal, principal solutions architect for Fusion-io, the solid-state storage provider, will make clear to audience members the benefits of solid-state technologies, both from a performance standpoint and in relation to TCO. Q&A with the panel to follow. Participants include panelists from Answers.com, Cloudmark, Percona and Craigslist.org. Read more.
Average rating: ****.
(4.25, 4 ratings)
This talk explains how TokuDB Fractal Trees work and presents both theoretical and empirical evidence of its performance advantages. Read more.
Vadim Tkachenko (Percona Inc), Morgan Tocker (Percona, Inc.)
Average rating: ***..
(3.50, 4 ratings)
This session is an overview of XtraBackup, a free, open-source hot backup solution for InnoDB and XtraDB engines. Read more.
Average rating: ****.
(4.75, 4 ratings)
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. Read more.
Architecture and Technology
Location: Ballroom H
Average rating: ****.
(4.00, 2 ratings)
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. Read more.
  • 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.