Effective MySQL : backup and recovery

Effective MySQL backup and recovery

The Essential Guide to Protecting Your Business Information Written by Oracle ACE Director and MySQL expert Ronald Bradford, Effective MySQL: Backup and Recovery covers all the options with detailed descriptions and syntax examples to ensure an appropriate backup and recovery plan can be developed....

Descripción completa

Detalles Bibliográficos
Autor Corporativo: Books24x7, Inc (-)
Otros Autores: Bradford, Ronald, author (author)
Formato: Libro electrónico
Idioma:Inglés
Publicado: New York : McGraw-Hill [2012]
Edición:1st edition
Colección:Oracle Press
Materias:
MySQL (Electronic resource)
Database management.
Relational databases.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629478406719
Tabla de Contenidos:
  • Intro
  • Effective MySQL
  • About the Author
  • About the Technical Editors
  • Contents
  • Acknowledgments
  • Introduction
  • Conventions
  • About MySQL
  • Code Examples
  • References
  • Chapter 1: The Five Minute DBA
  • Approaching a MySQL Backup
  • Determining Your Database Size
  • Choosing a Locking Strategy
  • Execution Time
  • Combining Information
  • Performing a MySQL Backup
  • Running mysqldump
  • Securing Your Backup
  • Benefits with mysqldump
  • More Information
  • Other Options
  • Conclusion
  • Chapter 2: Understanding Backup Options
  • Terminology
  • Choosing a Backup Strategy
  • Database Availability
  • Storage Engines
  • Locking Strategies
  • Lock Tables
  • Flush Tables
  • MySQL Topology
  • Static Backup Options
  • Filesystem Backup
  • Disadvantages
  • Advantages
  • SQL Dump
  • MySQL Replication Specific Options
  • Additional Options
  • Benefits
  • Recovery Considerations
  • Recommended Practices for Database Objects
  • Using Compression
  • Leveraging Network Devices
  • Disadvantages
  • Table Extract
  • Filesystem Snapshot
  • Using mylvmbackup
  • Designing Appropriate LVM Volumes
  • Other Considerations
  • InnoDB Hot Backup
  • MySQL Enterprise Backup (MEB)
  • XtraBackup
  • Options Not Discussed
  • Point in Time Requirements
  • Binary Logs
  • Binary Log Position
  • Binary Log Backup Options
  • File Copy
  • Replication
  • DRBD
  • Hardware Considerations
  • Data Source Consistency
  • Backup Security
  • Conclusion
  • Chapter 3: Understanding Business Requirements for Disaster Recovery
  • Defining Requirements
  • Determining Responsibilities
  • Terminology
  • Technical Resource Responsibilities
  • Decision Maker Responsibilities
  • Identifying Dependencies
  • Case Study
  • The MySQL Topology
  • Your Backup and Recovery Strategy
  • A Real Life Disaster
  • Technical Outcomes
  • The Decision Process
  • Essential External Communication.
  • Planning for the Worst Situation
  • Total SAN Failure
  • Power Disruption
  • Explosion
  • FBI Seizure
  • Blackout
  • Human Factors
  • Human Resources
  • Developing a Strategic Plan
  • Conclusion
  • Chapter 4: Using MySQL Replication
  • MySQL Replication Architecture
  • MySQL Replication Characteristics
  • MySQL Replication Limitations
  • Replication Lag
  • Consistency
  • Data Consistency
  • Schema Consistency
  • Object Consistency
  • Completeness
  • Replication Design Considerations
  • Binary Log Row Format
  • Unsafe Statements
  • Trigger Operation
  • Statement-based Replication (SBR)
  • Row-based Replication (RBR)
  • Semi-synchronous Replication
  • Replication Backup Considerations
  • Additional Prerequisite Checks
  • Checking Replication Lag
  • MySQL Temporary Tables
  • InnoDB Background Threads
  • Cold Backup Options
  • mysqldump Options
  • Filesystem Snapshot Options
  • MySQL Enterprise Backup (MEB) Options
  • XtraBackup Options
  • Architecture Design Considerations
  • Upcoming Replication Functionality
  • Conclusion
  • Chapter 5: Using Recovery Options
  • A Word About Testing
  • Determining the Type of Recovery Necessary
  • MySQL Software Failure
  • Crash Recovery
  • Testing InnoDB Crash Recovery
  • Monitoring InnoDB Crash Recovery
  • MyISAM Table Recovery
  • Other Storage Engines
  • Included Default Engines
  • Popular Third Party Engines
  • Table Definition Recovery
  • Performing a Static Recovery
  • MySQL Software Installation
  • MySQL Configuration
  • MySQL Data
  • Filesystem Copy
  • SQL Dump Recovery
  • MySQL Enterprise Backup (MEB) Recovery
  • XtraBackup Recovery
  • Performing a Point in Time Recovery
  • Binary Log Position
  • Using mysqldump
  • Filesystem Copy or Filesystem Snapshot
  • MySQL Enterprise Backup (MEB)
  • XtraBackup
  • Standalone Recovery
  • Leveraging the Replication Stream
  • Binary Log Mirroring
  • Recovery Verification.
  • The Backup and Recovery Quiz
  • Other Important Components
  • Conclusion
  • Chapter 6: MySQL Configuration Options
  • Data Management
  • Data Locations
  • Data Consistency
  • Binary Logging
  • MySQL Replication
  • Recovery
  • Conclusion
  • Chapter 7: Disaster Scenarios
  • Handling a MySQL Disaster
  • Notable MySQL Disasters
  • Magnolia
  • References
  • Couch Surfing
  • References
  • Journal Space
  • References
  • Percona
  • Reference
  • Other Notable Data Disasters
  • The Sidekick/Microsoft Data Loss
  • References
  • Github
  • Reference
  • TD Bank
  • References
  • General MySQL Disaster Situations
  • Binary Logging Not Enabled
  • A Single Server
  • Appropriate MySQL Security
  • Application Security
  • Appropriate MySQL Configuration
  • Read Only Replication Slaves
  • SQL Server Modes
  • Deleting MySQL Data
  • References
  • Deleting the InnoDB Data File
  • Deleting MySQL Binary Logs
  • Existing Backup and Recovery Procedure Disasters
  • MySQL Software Upgrades
  • Operating System Security Patch Upgrade
  • Handling MyISAM Corruption
  • The Call for Help
  • The Confirmation of a Serious Problem
  • The First Resolution Attempt
  • The Second Resolution Attempt
  • The Third Resolution Attempt
  • A Failed Database Backup
  • Detecting Hardware Faults
  • Conclusion
  • Missing Database Schemas
  • Restoring a Backup on a Running MySQL Instance
  • Handling InnoDB Specific Situations
  • Automatic Recovery
  • InnoDB Data Dictionary Inconsistency
  • Automatic Recovery Crashes the Database Server
  • Other MySQL Situations
  • Replication Inconsistency
  • RDS Recovery Failure
  • Common Downtime Causes
  • External Help
  • Conclusion
  • Chapter 8: Optimizing Backup and Recovery
  • Example Backup Environment
  • Using Compression
  • mysqldump
  • Compression Utilities
  • MySQL Enterprise Backup (MEB)
  • XtraBackup
  • Streaming Backups
  • Using SSH
  • Using nc.
  • MySQL Enterprise Backup (MEB)
  • XtraBackup
  • Remote Backups
  • mysqldump
  • MySQL Enterprise Backup (MEB)
  • XtraBackup
  • Parallel Processing
  • mydumper
  • Installation
  • Usage
  • Compression
  • More Information
  • XtraBackup
  • Incremental Backups
  • MySQL Enterprise Backup (MEB)
  • Producing a Full Restore
  • XtraBackup
  • Partial Backups
  • mysqldump
  • MySQL Enterprise Backup (MEB
  • XtraBackup
  • MySQL Backup Security
  • Encryption with ezNcrypt
  • mysqldump
  • Architectural Considerations
  • Conclusion
  • Chapter 9: MySQL in the Cloud
  • Amazon Relational Database Service (RDS)
  • Example Database Creation
  • MySQL Versions
  • Backup Options
  • mysqldump
  • Database Snapshot
  • MySQL Binary Logs
  • Recovery Options
  • SQL Dump
  • RDS Snapshot
  • Point in Time Recovery
  • Google Cloud SQL
  • Example Database Creation
  • Backup Options
  • mysqldump
  • Restore Options
  • HP Cloud Database as a Service (DBaaS)
  • MySQL Versions
  • Example Database Creation
  • Backup Options
  • mysqldump
  • Database Snapshot
  • Recovery Options
  • mysqldump
  • Database Snapshot
  • Point in Time Recovery
  • Cloud Impact on Backup and Recovery
  • Conclusion
  • Index.

Ejemplares similares