Schedule: Replication and Scale-Out sessions

Add to your personal schedule
Location: Ballroom D
Arjen Lentz (Open Query), Walter Heck (Open Query)
Average rating: *....
(1.83, 6 ratings)
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. Read more.
Add to your personal schedule
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.
Add to your personal schedule
Location: Ballroom F
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.
Add to your personal schedule
Location: Ballroom G
Peter Zaitsev (Percona Inc)
Average rating: ***..
(3.07, 14 ratings)
Scaling Applications with Caching, Sharding and Replication Read more.
Add to your personal schedule
Location: Ballroom D
Brian Aker (HP), Alan Kasindorf (Six Apart)
Average rating: ****.
(4.25, 4 ratings)
We’ve been talking about memcached for a while now. The topic is exciting, scary, and constantly evolving. You might have a hard time understanding how memcached works at all. You might be missing the “big picture”, or you might just need a handful of examples of how to properly handle common queries. Come here to learn more from the experts! Read more.
Add to your personal schedule
Location: Ballroom F
Jay Pipes (Rackspace Cloud), Padraig O'Sullivan (Akiban Technologies Inc.)
Average rating: ****.
(4.00, 1 rating)
The Drizzle Project is a fork of the MySQL 6.0 server. One of the many goals of Drizzle is to enable a large plugin ecosystem by improving, simplifying, and modernizing the application programming interfaces between the kernel and the modules providing services for Drizzle. This tutorial serves to showcase the new APIs for Drizzle's replication through a series of in-depth examples. Read more.
Add to your personal schedule
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.
Add to your personal schedule
Location: Ballroom C
Rob Young (Oracle/MySQL ), Mikael Ronstrom (MySQL)
Average rating: **...
(2.78, 9 ratings)
Join the MySQL and InnoDB Engineering teams as they describe the low-level technical details behind the MySQL 5.5 performance and scalability gains. Read more.
Add to your personal schedule
Location: Ballroom D
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.
Add to your personal schedule
Location: Ballroom A
Mats Kindahl (Oracle), Lars Thalmann (Oracle)
Average rating: ***..
(3.77, 13 ratings)
In this talk, the developers behind MySQL Replication walk through some of the new Replication features of MySQL 5.5 Read more.
Add to your personal schedule
Location: Ballroom D
Brian Moon (dealnews.com)
Average rating: ***..
(3.50, 2 ratings)
Memcached has become the de facto standard for caching web applications. But, many users jump in feet first without understanding what it does or perhaps more importantly what it does not do. Once you understand memcached, you may come to realize that it is what it does not do that makes it so good. Read more.
Add to your personal schedule
Location: Ballroom C
Giuseppe Maxia (Continuent), Eric Day (craigslist)
Average rating: ***..
(3.33, 3 ratings)
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. Read more.
Add to your personal schedule
Location: Ballroom B
Mark Matthews (Oracle), Todd Farmer (Oracle Corporation)
Average rating: **...
(2.40, 5 ratings)
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. Read more.
Add to your personal schedule
Location: Ballroom D
Robert Hodges (Continuent.com)
Average rating: ****.
(4.00, 2 ratings)
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! Read more.
Add to your personal schedule
Location: Ballroom C
Jan Kneschke (MySQL)
Average rating: ***..
(3.00, 2 ratings)
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. Read more.
Add to your personal schedule
Location: Ballroom D
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.
Add to your personal schedule
Location: Ballroom D
Baron Schwartz (VividCortex Inc)
Average rating: ****.
(4.12, 8 ratings)
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. Read more.
Add to your personal schedule
Location: Ballroom F
Chuck Bell (Oracle), Lars Thalmann (Oracle), Mats Kindahl (Oracle)
Average rating: ***..
(3.57, 7 ratings)
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. Read more.
Add to your personal schedule
Location: Ballroom A
Kentoku SHIBA (WildGrowth), Daniel Saito (MySQL)
Average rating: ***..
(3.00, 3 ratings)
Spider and Vertical Partitioning Storage Engine will be introduced by Giuseppe in this Conference. In this session, I'll introduce some additional tips for joinable database sharding using Spider and Vertical Partitioning. Read more.
Add to your personal schedule
Location: Ballroom E
Robert Hodges (Continuent.com), Jay Pipes (Rackspace Cloud)
Average rating: ***..
(3.20, 5 ratings)
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. Read more.
Add to your personal schedule
Location: Ballroom C
Eric Day (craigslist), Giuseppe Maxia (Continuent)
Average rating: ***..
(3.86, 7 ratings)
Many people view topics like Map/Reduce and queue systems as advanced concepts that require in-depth knowledge and time consuming software setup. Gearman is changing all that by making this barrier to entry as low as possible with an open source, distributed job queuing system. This session looks at advanced use cases that demonstrate the power and flexibility of distributed architectures. Read more.
Add to your personal schedule
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.
Add to your personal schedule
Location: Ballroom B
Sarah Sproehnle (Cloudera, Inc.), Chris Schneider (Ning.com)
Average rating: ***..
(3.56, 9 ratings)
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. Read more.
Add to your personal schedule
Location: Ballroom C
Nicklas Westerlund (Electronic Arts)
Average rating: **...
(2.50, 6 ratings)
Want to learn what the difference between a 10 server deployment and a 200 server deployment is in terms of administration? Best practices in large deployments? Got questions on centralized management and change management? Capacity planning? All these subjects and more will be covered in this session Read more.
Add to your personal schedule
Location: Ballroom D
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.
Add to your personal schedule
Location: Ballroom H
Andrew Aksyonoff (Sphinx Technologies)
Average rating: **...
(2.67, 3 ratings)
Sphinx is a FOSS full-text search engine that makes searching MySQL databases a breeze. This talk covers a number of recently developed advanced Sphinx features (RT indexes, parallel searching improvements, subquery caches, hitless indexes, "blended" indexing, SphinxQL interface, etc) in detail, explaining how and why to use them in your application. Read more.
Add to your personal schedule
Location: Ballroom A
Mark Callaghan (Facebook), Ryan Mack (Facebook), Ryan McElroy (Facebook)
Average rating: ****.
(4.06, 18 ratings)
Facebook runs MySQL on commodity servers. Commodity servers have become extremely fast. Learn about the methods we use to identify performance bottlenecks in MySQL and the projects we have completed or started to keep pace with hardware advances. Read more.
Add to your personal schedule
Location: Ballroom B
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! Read more.
Add to your personal schedule
Location: Ballroom E
Danil Zburivsky (The Pythian Group)
Average rating: ****.
(4.00, 3 ratings)
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. Read more.
Add to your personal schedule
Location: Ballroom C
Giuseppe Maxia (Continuent), Eric Day (craigslist)
Average rating: ***..
(3.50, 2 ratings)
Users of Gearman know that it is a distributed client/server system that allows great flexibility to developers and DBAs. Advanced users of this tool have come up with amazing examples of cunning hacks that will possibly help you in your daily tasks immediately or get you started in your path of creating your own hacks. Read more.
Add to your personal schedule
Location: Ballroom G
Frank Mashraqi (Opportunities)
Average rating: *....
(1.00, 4 ratings)
Caching is a powerful weapon in the arsenal of an enterprise data architect. Designing an optimal caching strategy for your organization can increase performance and help save cost, but a poorly designed caching strategy often hurts more than it helps. We will cover strategies encompassing popular options available for caching. Read more.
Add to your personal schedule
Location: Ballroom C
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. 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.