Effective MySQL Replication Techniques in Depth

The essential Oracle Press guide to MySQL replication Effective MySQL: Advanced Replication Techniquestakes 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

1. The Five Minute DBA
2. Diagnosing Common Replication Problems
3. Improving Standard Replication Features
4. Understanding Multi-Master Replication
5. MySQL Replication Tools
6. Extending Replication for Practical Needs
7. MySQL Configuration Options
8. Monitoring Replication
Appendix: A MySQL Replication Test Environment