MySQL Replication - Enhancing Scalability and Availability with MySQL 5.5

MySQL Replication has been widely deployed by some of the leading properties on the web and in the enterprise to deliver extreme levels of database scalability. It provides a simple mechanism for users to rapidly create multiple replicas of their database to elastically scale-out beyond the capacity constraints of a single instance, enabling them to serve rapidly growing database workloads.

Replication is also used as the foundation for delivering highly available database services, providing a means of mirroring data across multiple hosts to withstand failures of individual systems.

This white paper introduces the concepts behind replication and what can be achieved with MySQL Replication. It steps through setting up replication as well as handling failover. In addition, the changes introduced to replication in MySQL 5.5 are covered as well as the differences when replicating with MySQL Cluster.

If you already have a MySQL.com account, save time by logging in now.