Read-Write Splitting: Techniques, Challenges, and Solutions

Average rating: ****.
(4.12, 8 ratings)

Read-write splitting is a great way to scale your workload, but it isn’t as simple as you might think at first. Going from one to many servers adds complexity to your application architecture, infrastructure, and code. You need to be prepared for these changes.

This session will teach you common read-write splitting design patterns, and how to decide which one is best for your application. You’ll learn what changes you need to make in your code. We’ll see how to compute the capacity increase you can expect in your systems as a result. We’ll look at how to handle common problems such as replication delay, unavailability of a slave, and more. And you’ll learn good practices for preventing problems such as accidentally writing to a slave instead of the master (hey, mistakes happen).

Photo of Baron Schwartz

Baron Schwartz


Baron is the lead author of High Performance MySQL 2nd edition, and creator of Maatkit. He blogs at Xaprb. Baron is the Director of Consulting at Percona, a firm that helps customers build high-performance applications with open-source software stacks such as LAMP.

Comments on this page are now closed.


Gregory Glass
04/14/2010 4:43am PDT

Great speaker. Very easy to understand even for someone with less experience like me. The was easily the best session I’ve been to so far. Very informative, but at the same time not over anyones head.

  • 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

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@

Press and Media

For media-related inquiries, contact Maureen Jennings at

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.