Even though setting up MySQL Replication is a relatively simple task, there are several things that can be configured. In this tutorial, the developers behind MySQL Replication start by explaining the architecture and concepts and walk you through a configuration to show what you can do with it.
After getting an understanding of the setup, the tutorial continues with examples of using more advanced features like row-based replication, cluster replication, tricks of using the mysqlbinlog client program on the binary log, and fail-over solutions.
The tutorial ends with a brief summary of the new features that are being developed and how they can be used.
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.
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.
View a complete list of MySQL contacts.