Effective MySQL : replication techniques in depth

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
Otros Autores: Bradford, Ronald, author (author), Schneider, Chris, author
Formato: Libro electrónico
Idioma:Inglés
Publicado: New York : McGraw-Hill [2013]
Edición:1st edition
Materias:
MySQL (Electronic resource)
Database management.
SQL (Computer program language)
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628977506719
Tabla de Contenidos:
  • Cover
  • About the Authors
  • About the Technical Editors
  • Title Page
  • Copyright Page
  • Contents
  • Acknowledgments
  • Introduction
  • Conventions
  • About MySQL
  • Open Source Licenses
  • Common Technical Abbreviations
  • Code Examples
  • References
  • Chapter 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
  • Chapter 2: Diagnosing Common Replication Problems
  • MySQL Replication Architecture Review
  • Interpreting Replication Information
  • Binary Logs
  • Show Master Logs
  • Show Master Status
  • Show Slave Status
  • 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
  • Chapter 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
  • Chapter 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
  • Chapter 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
  • Chapter 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
  • Google Cloud SQL
  • Other Offerings
  • Conclusion
  • Chapter 7: MySQL Configuration Options
  • About MySQL System Variables
  • Binary Logging
  • MySQL Replication
  • Semisynchronous Replication
  • Security
  • MySQL Server Variables
  • InnoDB Variables
  • MySQL 5.6 Features
  • Universally Unique Identifier (UUID)
  • Crash-Safe Slaves
  • Replication Checksums
  • Multi-Threaded Slaves
  • Global Transaction Identifier (GTID).
  • User Privileges
  • SQL Commands and Functions
  • Binary Log Statements
  • Replication Statements
  • Replication Related Functions
  • Conclusion
  • Chapter 8: Monitoring Replication
  • Types of Monitoring
  • MySQL Configuration
  • Monitoring Granularity
  • Important MySQL Information
  • MySQL Error Log
  • Show Master Status
  • Show Slave Status
  • Show Global Status
  • Meta Files
  • Meta Tables
  • Monitoring Products
  • Dedicated Monitoring Products
  • System Monitoring Products
  • The Implementation of Monitoring
  • MySQL Enterprise Monitor
  • Cacti
  • MySQL Performance Monitor (MPM)
  • Poor Man's Replication Monitor
  • Troubleshooting Replication Incidents
  • Conclusion
  • Appendix: A MySQL Replication Test Environment
  • Manual Steps to Configure MySQL Replication
  • Using MySQL Sandbox
  • MySQL Sandbox Installation
  • MySQL Software Releases
  • Replication Setup with MySQL Sandbox
  • References
  • Using Virtual Servers
  • VirtualBox Installation
  • Testing and Verifying MySQL Replication
  • Conclusion
  • Index.

Ejemplares similares