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 replication to build scalable solutions. T...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Bradford, Ronald
Otros Autores: Schneider, Chris
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Emeryville, Calif. : McGraw-Hill/Osborne, 2012, ©2013.
Colección:Effective MySQL
Temas:
MySQL (Electronic resource)
Database management.
SQL (Computer program language)
Bases de données > Gestion.
SQL (Langage de programmation)
Database management
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Cover
  • About the Authors
  • Copyright
  • Dedication
  • Contents
  • Acknowledgments
  • Introduction
  • 1 The Five Minute DBA
  • The 2 A.M. Alert Notification
  • Show Slave Status
  • Identifying the Problem
  • Show Create Table
  • Rectifying the Problem
  • Sql_Slave_Skip_Counter
  • Addressing the Underlying Cause
  • Rectifying the Problem Correctly
  • Understanding Replication Issues
  • User Security
  • Configuration Options and Variables
  • Conclusion
  • 2 Diagnosing Common Replication Problems
  • MySQL Replication Architecture Review
  • Interpreting Replication Information
  • Binary Logs
  • Relay Logs
  • Replication Consistency
  • Identifying Data Inconsistencies
  • Identifying Schema Inconsistencies
  • Causes of Data Inconsistency
  • Common Replication Errors
  • MySQL Server ID
  • Missing Schema Objects
  • Ignoring Duplicate Rows
  • Understanding Replication Lag
  • Primary Causes of Lag
  • The MySQL Error Log
  • Simple Techniques to Improve and Minimize Lag
  • Advanced Techniques to Improve and Minimize Lag
  • Monitoring Replication
  • Conclusion
  • 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
  • Other Replication Topologies
  • Automating High Availability Failovers
  • Conclusion
  • 5 MySQL Replication Tools
  • Various MySQL Toolkits
  • Openark Kit
  • Percona Toolkit
  • MySQL Workbench Utilities
  • Replication Failover Managers
  • MySQL MHA
  • MMM
  • Flipper
  • Cluster Control
  • Cluster Management
  • Percona Replication Manager (PRM)
  • Replication Prefetch
  • MySQL Patches and Variants
  • Independent Community Users
  • Commercial Organizations
  • Conclusion
  • 6 Extending Replication for Practical Needs
  • Highly Requested Replication Features
  • MySQL Cluster
  • Galera Cluster for MySQL
  • Current Limitations
  • References
  • Installation
  • Percona XtraDB Cluster
  • MariaDB Galera Cluster
  • Galera Wrap-Up
  • Tungsten Replicator
  • Features
  • References
  • Prerequisites
  • Installation with Tungsten Sandbox
  • Manual Tungsten Installation
  • Alternative Tungsten Deployments
  • Unique Characteristics
  • Continuent Tungsten
  • Continuent Wrap-Up
  • SchoonerSQL
  • MySQL Replication Listener
  • MySQL in the Cloud
  • Amazon RDS for MySQL

Ejemplares similares