Effective MySQL Replication Techniques in Depth

The essential Oracle Press guide to MySQL replication

Effective MySQL: Advanced Replication Techniques takes you beyond the common usages of MySQL replication by revealing real-world methods for identifying and diagnosing the limitations and potential issues that are critical considerations in the successful design and management of a scalable database system.

Written by Oracle ACE Director, Ronald Bradford, and MySQL expert Chris Schneider, the book illuminates the advanced business requirements for high availability, data security, data consistency, and redundancy. Benefits and limitations with cloud computing and virtualization environments are discussed. Both open source and commercial offerings exist to extend the features of MySQL replication to support complex topologies. Knowing which products to employ can mean the difference between true high availability and painful downtime. This Oracle Press guide offers best practices for leveraging third-party tools to solve MySQL replication limitations.

Effective MySQL: Advanced Replication Techniques

• Contains a Five Minute DBA chapter which presents a real-world scenario and the correct way to manage it
• Features a convenient, portable format
• Filled with valuable, concentrated information addressing the challenges MySQL developers, architects, and DBAs face every day
• Explains how to successfully implement advanced replication to inexpensively link innumerable servers to a single purpose

Targeted coverage:
Diagnosing Common Replication Problems; Creating Better Replication; MySQL Replication Tools; MySQL Configuration Options; Extending Replication for Practical Needs; Monitoring Replication