Replication Tricks & Tips

Replication and Scale-Out
Location: Ballroom F Level: Intermediate
Average rating: ***..
(3.40, 5 ratings)

Replication is a versatile tool to use in your toolbox. It can be
used to solve many problems modern web architectures, as well as
various ways to simplify maintenance.

In this session, the replication developers will present a bag of
useful tips and tricks including, but not limited to:

  • Ways to set up multi-source replication
  • Multi-master setup do:s and don’t
  • Using the Blackhole engine
  • Using log for auditing
  • Ways to handle filtering
  • Keeping the system online
  • Examining the binary log
  • Using relay slaves
  • Splitting the replication stream
  • Handling fail-over
Photo of Mats Kindahl

Mats Kindahl


Mats Kindahl is lead software developer in the MySQL replication team. He is the main architect and implementor of MySQL’s row-based replication, but has also developed the unit testing framework used by MySQL.

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

Photo of Lars Thalmann

Lars Thalmann


Dr. Lars Thalmann is the technical lead of replication and backup
technology at MySQL. He has designed many of the features, and is
leading the development of replication, online backup, character sets
and XML. Dr. Thalmann has worked with clustering technology for many
years and is one of the developers of NDB Cluster, the storage engine
used in MySQL Cluster.

Comments on this page are now closed.


04/23/2009 5:38am PDT

I would have liked to see more information about how to setup multi-source replication.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at

Download the MySQL 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

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.