- Shopping Bag ( 0 items )
Other sellers (Paperback)
-
All (7) from $8.15
-
Used (7) from $8.15
Ships from: Aurora, IL
Usually ships in 1-2 business days
Ships from: Aurora, IL
Usually ships in 1-2 business days
Ships from: Front Royal, VA
Usually ships in 1-2 business days
Ships from: Front Royal, VA
Usually ships in 1-2 business days
Ships from: Greenwood, IN
Usually ships in 1-2 business days
Ships from: Springfield, VA
Usually ships in 1-2 business days
Ships from: Pueblo West, CO
Usually ships in 1-2 business days
Server bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. To protect your system from outages, MySQL provides several features that work well whether you're running directly on the hardware, on virtual machines, or in the cloud. But to use features such as replication, clusters, and monitoring tools effectively, you need to understand how they work together, and which combination of features will give you the most reliable system for a price you can afford.
Written by the people who designed these features, MySQL High Availability covers all aspects of reliability and high availability in MySQL from a practical point of view. You'll learn skills essential to any organization that depends on a MySQL database.
Topics include:
Foreword;
Preface;
Audience;
Organization of This Book;
Conventions Used in This Book;
Using Code Examples;
We’d Like to Hear from You;
Safari® Books Online;
Acknowledgments;
Replication;
Chapter 1: Introduction;
1.1 What’s This Replication Stuff Anyway?;
1.2 So, Backups Are Not Needed Then?;
1.3 What’s with All the Monitoring?;
1.4 Is There Anything Else I Can Read?;
1.5 Conclusion;
Chapter 2: MySQL Replication Fundamentals;
2.1 Basic Steps in Replication;
2.2 A Brief Introduction to the Binary Log;
2.3 Performing Common Tasks with Replication;
2.4 Conclusion;
Chapter 3: The Binary Log;
3.1 Structure of the Binary Log;
3.2 Logging Statements;
3.3 Logging Transactions;
3.4 Binary Log Management;
3.5 The mysqlbinlog Utility;
3.6 Binary Log Options and Variables;
3.7 Conclusion;
Chapter 4: Replication for High Availability;
4.1 Redundancy;
4.2 Planning;
4.3 Procedures;
4.4 Conclusion;
Chapter 5: MySQL Replication for Scale-Out;
5.1 Scaling Out Reads, Not Writes;
5.2 The Value of Asynchronous Replication;
5.3 Managing the Replication Topology;
5.4 Hierarchal Replication;
5.5 Specialized Slaves;
5.6 Data Sharding;
5.7 Managing Consistency of Data;
5.8 Consistency in a Hierarchal Deployment;
5.9 Conclusion;
Chapter 6: Advanced Replication;
6.1 Replication Architecture Basics;
6.2 Running Replication over the Internet;
6.3 Finer-Grained Control over Replication;
6.4 Options for Handling Broken Connections;
6.5 How the Slave Processes Events;
6.6 Slave Safety and Recovery;
6.7 Multisource Replication;
6.8 Row-Based Replication;
6.9 Conclusion;
Monitoring and Disaster Recovery;
Chapter 7: Getting Started with Monitoring;
7.1 Ways of Monitoring;
7.2 Benefits of Monitoring;
7.3 System Components to Monitor;
7.4 Monitoring Solutions;
7.5 Linux and Unix Monitoring;
7.6 Mac OS X Monitoring;
7.7 Microsoft Windows Monitoring;
7.8 Monitoring as Preventive Maintenance;
7.9 Conclusion;
Chapter 8: Monitoring MySQL;
8.1 What Is Performance?;
8.2 MySQL Server Monitoring;
8.3 Database Performance;
8.4 Best Practices for Improving Performance;
8.5 Conclusion;
Chapter 9: Storage Engine Monitoring;
9.1 MyISAM;
9.2 InnoDB;
9.3 Conclusion;
Chapter 10: Replication Monitoring;
10.1 Getting Started;
10.2 Server Setup;
10.3 Inclusive and Exclusive Replication;
10.4 Replication Threads;
10.5 Monitoring the Master;
10.6 Monitoring Slaves;
10.7 Replication Monitoring with MySQL Administrator;
10.8 Other Items to Consider;
10.9 Conclusion;
Chapter 11: Replication Troubleshooting;
11.1 What Can Go Wrong;
11.2 Tools for Troubleshooting Replication;
11.3 Best Practices;
11.4 Reporting Replication Bugs;
11.5 Conclusion;
Chapter 12: Protecting Your Investment;
12.1 What Is Information Assurance?;
12.2 Information Integrity, Disaster Recovery, and the Role of Backups;
12.3 Backup Utilities and OS-Level Solutions;
12.4 Backup and MySQL Replication;
12.5 Automating Backups;
12.6 Conclusion;
Chapter 13: MySQL Enterprise;
13.1 Getting Started with MySQL Enterprise;
13.2 MySQL Enterprise Components;
13.3 Using MySQL Enterprise;
13.4 Conclusion;
High Availability Environments;
Chapter 14: Cloud Computing Solutions;
14.1 What Is Cloud Computing?;
14.2 Cloud Computing Use Cases;
14.3 Cloud Computing Benefits;
14.4 Cloud Computing Vendors;
14.5 AWS;
14.6 MySQL in the Cloud;
14.7 Open Source Cloud Computing;
14.8 Conclusion;
Chapter 15: MySQL Cluster;
15.1 What Is MySQL Cluster?;
15.2 Architecture of MySQL Cluster;
15.3 Example Configuration;
15.4 Achieving High Availability;
15.5 Achieving High Performance;
15.6 Conclusion;
Replication Tips and Tricks;
My Slave Stopped. Now What?;
Examining the Binary Log with Verbose;
Using Replication to Repopulate a Table;
Using MySQL Proxy to Perform Multimaster Replication;
Using a Default Storage Engine;
MySQL Cluster Multisource Replication;
Multichannel Replication with Failover;
Using the Current Database to Filter;
More Columns on Slave Than Master;
Fewer Columns on Slave Than Master;
Replicate Selected Rows to Slave;
Replication Heartbeat;
Ignoring Servers in Circular Replication;
Feature Preview: Time-Delayed Replication;
Feature Preview: Scriptable Replication;
Feature Preview: The Oracle Algorithm;
Colophon;
Overview
Server bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. To protect your system from outages, MySQL provides several features that work well whether you're running directly on the hardware, on virtual machines, or in the cloud. But to use features such as replication, clusters, and monitoring tools effectively, you need to understand how they work together, and which combination of features will give you ...