Replication Tricks & Tips

Mats Kindahl (Oracle), Lars Thalmann (Oracle)
General
Location: Ballroom G
Average rating: ***..
(3.00, 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

Oracle

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

Oracle

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.

Comments

Picture of Juan-Carlos Sanchez
Juan-Carlos Sanchez
04/19/2010 4:12pm PDT

Excellent presentation! Thank you very much. Love the idea of using the blackhole engine in my replication

  • 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 yromaine@oreilly.com

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@ oreilly.com

Press and Media

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

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.