Advanced MySQL Replication Architectures

Luís Soares (Oracle)
Location: Portland 252
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 Luís Soares

Luís 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 2:41pm PDT

Looks like the slide deck is here

Picture of Michael Shadle
Michael Shadle
07/19/2012 2:15pm 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