MySQL High Availability Tools for Building Robust Data Centers
Server bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. MySQL has several features that can help you protect your system from outages, whether it's running on hardware, virtual machines, or in the cloud. MySQL High...
| Autor principal: | |
|---|---|
| Otros Autores: | , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
O'Reilly Media
2010.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628361706719 |
Tabla de Contenidos:
- Table of Contents; Foreword; Preface; Audience; Organization of This Book; Part I, Replication; Part II, Monitoring and Disaster Recovery; Part III, High Availability Environments; Conventions Used in This Book; Using Code Examples; We'd Like to Hear from You; Safari® Books Online; Acknowledgments; Part I. Replication; Chapter 1. Introduction; What's This Replication Stuff Anyway?; So, Backups Are Not Needed Then?; What's with All the Monitoring?; Is There Anything Else I Can Read?; Conclusion; Chapter 2. MySQL Replication Fundamentals; Basic Steps in Replication; Configuring the Master
- Configuring the SlaveConnecting the Master and Slave; A Brief Introduction to the Binary Log; What's Recorded in the Binary Log; Watching Replication in Action; The Binary Log's Structure and Content; Python Support for Managing Replication; Basic Classes and Functions; Operating System; Server Class; Server Roles; Creating New Slaves; Cloning the Master; Cloning the Slave; Scripting the Clone Operation; Performing Common Tasks with Replication; Reporting; Handling reporting in Python; Scheduling tasks on Unix; Scheduling tasks on Windows Vista; Conclusion; Chapter 3. The Binary Log
- Structure of the Binary LogBinlog Event Structure; Logging Statements; Logging Data Manipulation Language Statements; Logging Data Definition Language Statements; Logging Queries; Current database; Current time; Context events; Thread ID; LOAD DATA INFILE Statements; Binary Log Filters; Triggers, Events, and Stored Routines; Statements that define or destroy stored programs; Statements that invoke triggers and stored routines; Stored Procedures; Stored Functions; Events; Special Constructions; The LOAD_FILE function; Nontransactional Changes and Error Handling; Logging Transactions
- Transaction CacheHow nontransactional statements are logged; How to avoid replication problems with nontransactional statements; Distributed Transaction Processing Using XA; Binary Log Management; The Binary Log and Crash Safety; Binlog File Rotation; Incidents; Purging the Binlog File; The mysqlbinlog Utility; Basic Usage; Reading remote files; Interpreting Events; Query event post header and body; Format description event post header and body; Binary Log Options and Variables; Conclusion; Chapter 4. Replication for High Availability; Redundancy; Planning; Slave Failures; Master Failures
- Relay FailuresDisaster Recovery; Procedures; Hot Standby; Handling a switchover in Python; Dual Masters; Shared disks; Replicated disks using DRBD; Bidirectional replication; Semisynchronous Replication; Configuring semisynchronous replication; Monitoring semisynchronous replication; Slave Promotion; The traditional method for promoting a slave; A revised method for promoting a slave; Slave promotion in Python; Circular Replication; Conclusion; Chapter 5. MySQL Replication for Scale-Out; Scaling Out Reads, Not Writes; The Value of Asynchronous Replication; Managing the Replication Topology
- Example of an Application-Level Load Balancer
