The Replication Tutorial

Replication and Scale-Out, Tutorial
Location: Ballroom E Level: Novice
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.

In this session, the developers behind MySQL Replication will go through the architecture and concepts behind replication, introduce a number of basic replication setups, and in a step-by-step manner describe how to configure replication for the various setups.

After getting an understanding for how to set up basic replication scenarios, we will go through a selection of more advanced uses, such as: setting up row-based replication, writing clients for controlling and monitoring replication, and also an introduction to the basic tools for analyzing replication problems.

In the session we will also cover how to improve resistance to failures in a replication set-up by using slave promotion techniques, dual-master setups, and semi-synchronous replication to avoid losing transactions.

In order to allow session participants to test replication and experiment with setting it up, tools to easily configure and set up replication on your local machine will be available before the session. You can install the tools before the session, but it is not necessary for following the tutorial.

Photo of Mats Kindahl

Mats Kindahl


Mats Kindahl lead software developer at MySQL/Oracle. He is the main architect and implementor of the MySQL row-based replication and several other replication features.

He is co-author of the book MySQL High Availability (O’Reilly Media, Inc.)

In the time before starting at MySQL, he has worked with research in formal methods, automated program analysis, distributed systems, and as implementor of C/C++ compilers.

Photo of Lars Thalmann

Lars Thalmann


Dr. Lars Thalmann is the development director for MySQL replication, backup, and connectors. He is responsible for the strategy and development of these features and leads the corresponding engineering teams. Thalmann has worked with MySQL development since 2001, when he started as a MySQL Cluster developer. More recently, he has driven the creation and development of the MySQL backup feature, has guided the evolution of MySQL replication since 2004, and has been a key player in the development of MySQL Cluster replication. Thalmann holds a doctorate in Computer Science from Uppsala University, Sweden. He is one of the authors of the “MySQL High Availability” book.

Comments on this page are now closed.


Picture of Juan-Carlos Sanchez
Juan-Carlos Sanchez
04/19/2010 9:02am PDT

Excellent presentations! Thank you very much

  • 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.