Backup and Replication Integration Techniques

Average rating: ****.
(4.00, 3 ratings)

The new MySQL Backup system has been improved to compliment the replication system. There are several key scenarios where backup can improve replication. These include failover, slave propagation, protection for restore, and routine use of backup with replication.

The scenarios discussed will include common replication tasks where backup can be used including the following.

  • Make a copy of a master to setup a new slave.
  • Make a copy of a slave to another server that will become the
    master of the slave as soon as possible.
  • Make a copy of a slave to another slave so the new slave
    can join the replication topology.
  • My master died, I have ten slaves, each at a different position.

The session will also examine a number of use cases discussing how backup and replication interact including the following.

  • Backup performed on a master.
  • Restore performed on a master.
  • Backup performed on a slave.
  • Restore performed on a slave.
  • Backup run with no binary log.
  • Restore run with binary log turned on but no slaves attached.
Photo of Chuck Bell

Chuck Bell


Dr. Charles A. Bell conducts research in emerging technologies and agile development techniques. He works for Sun Microsystems as a senior software engineer on the backup and replication team. He is currently one of the principle developers of the backup system. His contributions to the backup system include the new logging mechanism, the default drivers, and numerous minor enhancements. Working exclusively on the Windows platform, he is also the resident Windows expert for the team.

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.

Photo of Mats Kindahl

Mats Kindahl


Mats Kindahl is a lead software engineer of 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, program analysis, distributed systems, and as developer of C/C++ compilers.

Comments on this page are now closed.


04/23/2009 7:44am PDT

excellent speaker and content

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.