Effective MySQL Replication Techniques in Depth

The Essential Guide to Scaling Your Business Solution

Written by Oracle ACE Director and MySQL expert Ronald Bradford, with coauthor Chris Schneider, Effective MySQL: Replication Techniques in Depth describes what is needed to understand and implement MySQL replicationto build scalable solutions. This book includes detailed syntax examples to demonstrate the features, options, and limitations of native MySQL replication. Providing an evaluation of various new replication features andadditional third-party product implementations, this Oracle Press guide helps to ensure your MySQL environment can support the various high-availability needs of your business.

• Master the strengths and limitations of native asynchronous replication in a MySQL topology
• Identify the important features to improve replication for growing business requirements
• Recognize the key business factors to determine your optimal highavailability needs
• Understand the benefits of using MySQL replication for failover scenarios
• Identify the key configuration variables and SQL commands affecting master/ slave replication
• Learn about the advancements in replication techniques provided by new products, including Tungsten Replicator and Galera
• Optimize your replication management with various utilities and toolkits

Find additional detailed information and presentations at EffectiveMySQL.com.

Table of Contents

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