Advanced MySQL Replication Architectures

Location: Portland 252 Level: Intermediate
Average rating: ****.
(4.33, 3 ratings)

Replication is a simple-to-use, robust, and tried technique used
for achieving web-scale performance and high-availability. Basic
replication techniques include master-slave replication used to
perform backups and reporting without bringing the master off-line.

This presentation covers techniques to leverage MySQL Replication
for more advanced solutions: aggregating data from multiple data
centers, using hierarchical replication to scale out to thousands of
servers, mixing MySQL servers and other database servers, and using
esoteric slaves such as external full-text search engines,
web-cache layers, or other non-traditional or non-relational
components to handle special requirements.

Photo of Luis Soares

Luis Soares


Luís Soares is a Senior Software Engineer and the MySQL
Replication Team lead at Oracle. He has been into replication technologies since 2002. Before joining the MySQL team, back in 2008, he was both a post-graduate student and a researcher at the University of Minho, Portugal, where he designed and implemented group-based replication protocols. Before that, he worked for a
Portuguese multi-national company as a system analyst.

Comments on this page are now closed.


Picture of Hart Hoover
Hart Hoover
07/19/2012 7:41am PDT

Looks like the slide deck is here

Picture of Michael Shadle
Michael Shadle
07/19/2012 7:15am PDT

If there are slides, could you post them? Thanks :)


For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at (707) 827-7065 or

View a complete list of OSCON contacts