Book description
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 replication to 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 and additional 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
- Cover
- About the Authors
- Copyright
- Dedication
- Contents
- Acknowledgments
- Introduction
- 1 The Five Minute DBA
- 2 Diagnosing Common Replication Problems
-
3 Improving Standard Replication Features
- Extending Asynchronous Behavior
- Semisynchronous Replication
- Synchronous Replication
- Securing Replication with SSL
- Making MySQL SSL Ready
- New Replication Features
- New and Improved Data Integrity
- New Performance Improvements for Replication
- New Replication Management Features
- Balancing Read and Write Load
- Conclusion
-
4 Using Multi-Master Replication
- MySQL Replication Failover Capabilities
-
Active/Passive Multi-Master Replication
- Required Multi-Master Configuration Settings
- Optional Multi-Master Configuration Settings
- Other Configuration Variables to Consider
- Example Configuration
- Replication Setup
- Multi-Master Replication Verification
- Manual Failover Process
- Real World Usage Complications
- Additional Slave Servers
- Read and Write Load Balancing
- Circular Replication
- Automating High Availability Failovers
- Conclusion
- 5 MySQL Replication Tools
- 6 Extending Replication for Practical Needs
- 7 MySQL Configuration Options
- 8 Monitoring Replication
- A A MySQL Replication Test Environment
- Index
Product information
- Title: Effective MySQL Replication Techniques in Depth
- Author(s):
- Release date: September 2012
- Publisher(s): Oracle Press
- ISBN: 9780071791878
You might also like
book
MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs
Know how locks work in MySQL and how they relate to transactions. This book explains the …
book
Efficient MySQL Performance
You'll find several books on basic or advanced MySQL performance, but nothing in between. That's because …
book
High Performance MySQL, 2nd Edition
High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Written by …
book
Understanding MySQL Internals
Although MySQL's source code is open in the sense of being publicly available, it's essentially closed …