MySQL Replication

MySQL Replication enables users to cost-effectively deliver application performance, scalability and high availability. Many of the world's most trafficked web properties like Facebook, Google and eBay rely on MySQL Replication to serve millions of users and handle their exponentially growth. MySQL Replication is easy to set up and allows for complex chained replication topologies to achieve massive scalability.

Scale-Out with MySQL Replication

Using MySQL Replication, organizations are able to scale out their applications by distributing their data workloads across MySQL server farms. This gives organizations the flexibility to easily add more servers to increase capacity.

High Availability with MySQL Replication

MySQL Replication is the most common approach to delivering High Availability (HA) for MySQL databases. For example, organizations can implement a dedicated standby Master or promote an existing Slave server to take over in the event the master goes offline, either due to a failure or for planned maintenance.

Replication Modes

MySQL Replication is asynchronous and enables data to be replicated from one MySQL Master to one or more MySQL Slaves. Plus, MySQL Replication supports multiple logging types to optimize performance for each of the types of updates made to the database.

• Row Based Replication - Individual rows are replicated, rather than SQL statements, which is most appropriate when updates affect only a few rows. Fewer locks are needed which allows higher database concurrency.
• Statement Based Replication - SQL statements are replicated, rather than the actual data being updated. For updates that affect many rows, Statement Based Replication results in less data being logged.
• Mixed Format Replication - MySQL can dynamically change between the replication formats discussed above in real-time, according to the event being logged

Managing MySQL Replication

MySQL Enterprise Monitor includes the Replication Monitor, which provides a visual dashboard to manage replicated MySQL servers. Using the Replication Monitor organizations get a consolidated, real-time view into the health, performance and availability of all replication topologies. Plus, the Replication Advisor Rules help DBAs to proactively identify and correct Replication related problems such as Master/Slave performance and latency issues, before they can become costly outages.

Additional Resources

White Papers

• MySQL Replication - Enhancing Scalability and Availability with MySQL 5.5
• Getting Started with MySQL Replication on Windows

On Demand Webinars

• What's New in MySQL 5.6 - Part 2: Replication Enhancements
• MySQL Replication - Latest Enhancements in MySQL 5.5
• Getting Started with MySQL Replication on Windows
• Geographic Replication with MySQL Cluster