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

Ronald Bradford is an Oracle ACE Director and MySQL Community Member of the Year. He is also the visionary force behind this series. Bradford is a respected industry expert with more than 20 years of experience in the relational database field, with 12 years of experience working with MySQL. He combines his extensive consulting expertise with numerous public speaking events at conferences worldwide. Bradford is the author of Effective MySQL: Backup and Recovery and coauthor of Effective MySQL: Optimizing SQL Statements. He is the all-time top individual MySQL blogger, and his website is http://ronaldbradford.com.

Chris Schneider is a long-time MySQL Community Member and user. Throughout his career, he has designed, implemented, and maintained small- to large-scale MySQL installations while training and mentoring teams of database administrators. This includes building architectures from the ground up and improving on those that were currently in place, while emphasizing scalability, performance, and ease of use. Schneider has contributed to GoDaddy.com, Facebook.com, VMware, Virident, Plaxo.com, Ning.com, among other companies.