Schedule: Replication and Scale-Out sessions

Add to your personal schedule
Location: Ballroom B
Lars Thalmann (Oracle), Alex Roedling (Oracle)
Average rating: ****.
(4.60, 5 ratings)
The developers behind MySQL Replication describe the new features. After a quick review of what MySQL 5.5 brings, focus turns to the features that are coming after MySQL 5.5. Read more.
Add to your personal schedule
Location: Ballroom D
John Smiley (Amazon.com)
Average rating: **...
(2.14, 7 ratings)
Amazon engineers share experiences managing a large fleet of MySQL databases. Read more.
Add to your personal schedule
Location: Ballroom A
Jay Janssen (Percona, Inc.)
Average rating: ***..
(3.57, 7 ratings)
In the midst of many attempts to "solve" the RDBMS high availability problems, the vast majority of Yahoo sites are still using plain old boring MySQL replication to accomplish HA. This talk will cover the principles of this architecture, it's advantages and disadvantages, as well what we see as needed for future HA advances. It's old-school, it's crude, but somehow it solves most HA problems. Read more.
Add to your personal schedule
Location: Ballroom B
Giuseppe Maxia (Continuent)
Average rating: ***..
(3.33, 3 ratings)
Database technology is seldom simple. Unless you are dealing with an embedded, self containing database such as SQLite, chances are that your data management requires a complex system involving one or more database servers. Whether you need to test new systems or benchmark existing scenarios, your common need is to isolate the system. This talk tells how to tame database systems into obedience. Read more.
Add to your personal schedule
Location: Ballroom A
Ori Herrnstadt (FoundationDB)
Average rating: ****.
(4.00, 3 ratings)
Complex normalized schemas can make database systems slow and inefficient. This presentation explores a storage layer that eliminates most joins in such systems by pre-joining the data. Data in this storage layer can be accessed using an object API without the overhead of an object-relational mapping layer. It can also be accessed using standard SQL for efficient complex multi-table reporting. Read more.
Add to your personal schedule
Location: Ballroom B
Average rating: ****.
(4.14, 7 ratings)
When replication fails, it can be difficult to fix. This talk will show you how to diagnose the failure and, when possible, safely resume replication. Read more.
Add to your personal schedule
Location: Ballroom C
Tags: dba, schema
Danil Zburivsky (The Pythian Group)
Average rating: ****.
(4.20, 5 ratings)
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.
Add to your personal schedule
Location: Ballroom B
Tags: dba, scale_out
Average rating: ***..
(3.57, 7 ratings)
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.
Add to your personal schedule
Location: Ballroom C
Gerardo Narvaja (SkySQL Inc.)
Traditionally replication has been monitored using the information in SHOW SLAVE STATUS, however it doesn't always represent the full picture. This presentation will outline how combining different methodologies it is possible to obtain a more accurate picture about replication health. Read more.
Add to your personal schedule
Location: Ballroom A
Dan Rogart (Zynga), mohan krishnan (Zynga)
Average rating: ***..
(3.33, 3 ratings)
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.
Add to your personal schedule
Location: Ballroom A
Tags: case_study
Tao Cheng (AOL)
Average rating: ***..
(3.00, 3 ratings)
AOL deployed its large scale Real Time News (RTN) system in 2007. This system receives news updates from over 30,000 sources on every second around the clock. Today, its data store, MySQL, has accumulated over several billions of rows and terabytes of data. However, news are delivered to end users in close to real time fashion. This presentation shares how it is done and the lessons learned. Read more.
Add to your personal schedule
Location: Ballroom E
Venu Anuganti (ScaleIN)
Average rating: *....
(1.00, 1 rating)
This is a DBA or Data Architect perspective session which covers designing MySQL as data warehouse solution to handle tera bytes of data which compromises OLTP, ETL, OLAP and reporting Read more.
Add to your personal schedule
Location: Ballroom F
Matt Freels (Twitter)
Average rating: *....
(1.67, 3 ratings)
At Twitter, we have gone through many iterations of storage systems as we have coped with tremendous growth. We have been able to solve many general distributed storage problems in a framework named Gizzard. This has allowed us to quickly and safely develop specialized components for the parts of Twitter that can no longer handle the scale at which they are required to operate. Read more.
Add to your personal schedule
Location: Ballroom H
Tags: nosql, redis
Tim Lossen (wooga - world of gaming)
Average rating: **...
(2.50, 2 ratings)
As an in-memory database, Redis offers an order-of-magnitude reduction in query roundtrip latency, but also introduces new challenges. This case study recounts how we successfully scaled up two Facebook games with Redis, and what we learned on the way. Read more.
Add to your personal schedule
Location: Ballroom A
Matt Ingenthron (Couchbase, Inc.)
Average rating: ****.
(4.00, 1 rating)
With contemporary web applications, data is never isolated to one store. Memcached has long been a partner to MySQL; now Membase, a persistent, replicated, clustered memcached-protocol-compatible datastore is used alongside MySQL for simple, fast key-value access. This session will dispel the idea of needing to choose between SQL or NoSQL, showing how you can be both rich and fast. Read more.
Add to your personal schedule
Location: Ballroom E
Tags: sharding
Gwen Shapira (Pythian)
Average rating: ****.
(4.00, 4 ratings)
Sharding is a pain. Anyone who says differently is trying to sell you something. Gwen Shapira will share stories from her 13 years of sharding experience: Learn how you can have less-painful sharded architecture using your favorite relational database. Read more.
Add to your personal schedule
Location: Ballroom H
Mat Keep (MySQL), Bernhard Ocklin (Oracle Svenska AB)
Discover how MySQL Cluster can be used to store session data for the new generation of web applications that demand persistence, massive scalability and high levels of availability. We'll cover what today's applications need from a session store; why MySQL Cluster is so suited to meeting those needs and how to implement them. To make this more real we'll present some real life case studies. Read more.
Add to your personal schedule
Location: Ballroom E
Sarah Novotny (NGINX)
Average rating: *****
(5.00, 1 rating)
MySQL's replication system has been a core feature often touted for scaling (sort of) and redundancy (sort of). I'll describe a client's extensive use of MySQL replication (they have more than 200 MySQL instances replicating to one another) as a reference for the many uses and misuses of replication. Read more.
Add to your personal schedule
Location: Ballroom F
Seppo Jaakola (Codership), Alexey Yurchenko (Codership)
Average rating: ***..
(3.67, 3 ratings)
Galera provides synchronous multi-master replication for MySQL/InnoDB. In a sense, it works like MySQL/Cluster but on top of InnoDB storage engine. Is this too good to be true? Read more.
Add to your personal schedule
Location: Ballroom F
Seppo Jaakola (Codership), Alexey Yurchenko (Codership)
Average rating: ***..
(3.00, 2 ratings)
Aside from traditional master-slave setup used mostly for HA and read scale-out, there is an established history of attempts at multi-master replication with MySQL. In this presentation we will look at what multi-master replication can do for us and compare different approaches of doing it. Read more.
Add to your personal schedule
Location: Ballroom A
Daniel Peek (Facebook)
Average rating: ****.
(4.20, 5 ratings)
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.
Add to your personal schedule
Location: Ballroom C
Moshe Shadmon (ScaleDB)
ScaleDB is a pluggable storage engine for MySQL. It turns MySQL into an enterprise-class, highly-available, clustered database that scales dynamically in a public and private cloud. Read more.
Add to your personal schedule
Location: Ballroom B
Mark Callaghan (Facebook), Ryan Mack (Facebook), Vamsi Ponnekanti (Facebook)
Average rating: ****.
(4.33, 3 ratings)
The Facebook database engineering team works with the community and on its own to make MySQL better for data center deployments. This work is visible in the Facebook patch, bugs fixed in official MySQL and features sponsored in other distributions. We will describe work to support a large number of large databases. We focus on backup, replication and quality of service. Read more.
Add to your personal schedule
Location: Ballroom D
Justin Swanhart (Percona), Ryan Lowe (Percona)
Average rating: ****.
(4.67, 3 ratings)
This talk describes using summary tables to improve application performance. It focuses on Flexviews, an open source toolkit based on MySQL stored procedures. Flexviews maintains summary tables and supports joins and aggregation. I'll show at a high level how Flexviews works and how it can be used to improve application performance. Examples will be provided for both OLTP and OLAP workloads. Read more.
Add to your personal schedule
Location: Ballroom E
Sunny Gleason (SunnyCloud)
Average rating: ****.
(4.00, 2 ratings)
This presentation introduces the St8 server, an open-source, REST-enabled storage service built using Jersey, Jetty, Guice, and most importantly, HailDB (formerly Embedded InnoDB). We describe interfacing HailDB with Java using JNA, and review benchmarks showing just how fast the service can be (including SSD as well as single-disk and RAID0 benchmarks). Read more.
Add to your personal schedule
Location: Ballroom F
Mark Konetchy (Facebook)
Average rating: ***..
(3.67, 3 ratings)
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.
Add to your personal schedule
Location: Ballroom H
Darpan Dinker (Schooner Information Technology, Inc.), Brian O’Krafka (Schooner Information Technology)
Most MySQL deployments use some form of replication. Whether the reason is availability, scalability, backup, disaster recovery or archiving, understanding the performance characterization and trade-offs is critical to design and planning. If you have always wondered when and why to choose async/semi-sync/sync MySQL replication, DRBD or other interoperable technologies, this session is for you. Read more.
  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

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

Media Partners Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press & Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Bulletin

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts