Advanced MySQL Replication Architectures

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.