CITATION

Bradford, Ronald. Effective MySQL Backup and Recovery. US: McGraw-Hill Osborne Media, 2012.

Effective MySQL Backup and Recovery

Published:  June 2012

eISBN: 9780071788588 0071788581 | ISBN: 9780071788571

Book description:

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. Featuring a side-by-side evaluation of the various backup strategies and complementary recovery implementations, this Oracle Press book helps you to protect your MySQL data from a wide range of disaster situations.

  • Learn how different backup strategies affect locking and system availability

  • Identify the importance of static backup options and point-in-time requirements

  • Recognize the important business factors to determine your optimal data protection requirements

  • Understand the benefits of using MySQL replication for leveraging different backup strategies

  • Understand the benefits and risks of implementing solutions with MySQL in the cloud

  • Identify key configuration variables that affect data durability and performance

  • Find out about the types of possible disasters and develop a robust plan to address them

  • Optimize your backup approach with compression, streaming, incremental, and parallel options

Ronald Bradford is an Oracle ACE Director and MySQL Community Member of the Year. He is also the visionary force behind the Effective MySQL series Ronald is a respected industry expert with more than 20 years of experience in the relational database field, with 12 years of experience working with MySQL. He combines his extensive consulting expertise with numerous public speaking events at conferences worldwide. Ronald is the all-time top individual MySQL blogger.

Keywords: EFFECTIVE MYSQL, MYSQL BACKUP & RECOVERY, RONALD BRADFORD, PATRICK GALBRAITH, BRADFORD, BRADFERD, BOOK, GUIDE, HOW TO, ORACLE PRESS, ORACLE, ORACLE ACE, FIVE MINUTE DBA, DATABASE ADMINSTRATOR, BACKUP, RECOVERY, OPTIONS, BUSINESS REQUIREMENTS, REPLICATION, MYSQL CONFIGURATION, DISASTER, OPTIMIZING, EFFECTIVE MYSQL OPTIMIZING SQL STATEMENTS, SCHWARTZ, HIGH PERFORMANCE MYSQL OPTIMIZATION, BACKUPS, REPLICATION, AND MORE, DAVIES, HIGH AVAILABILITY MYSQL COOKBOOK, BELL, MYSQL HIGH AVAILABILITY: TOOLS FOR BUILDING ROBUST DATA CENTERS, ORACLE DATABASE 11G THE COMPLETE REFERENCE, ORACLE DATABASE 11G A BEGINNER'S GUIDE, ORACLE DATABASE 11G PL/SQL PROGRAMMING, ORACLE DATABASE 11G NEW FEATURES, ORACLE DATABASE 11G DBA HANDBOOK, ORACLE DATABASE 11G SQL, OCA ORACLE DATABASE 11G ADMINISTRATION I EXAM GUIDE, OCA/OCP MYSQL DATABASE ADMINISTRATOR ALL-IN-ONE EXAM GUIDE, OCA ORACLE DATABASE 11G SQL FUNDAMENTALS I EXAM GUIDE, OCP ORACLE DATABASE 11G NEW FEATURES FOR ADMINISTRATORS EXAM GUIDE, OCP ORACLE DATABASE 11G ADMINISTRATION II EXAM GUIDE, ORACLE DATABASE 11G RMAN BACKUP & RECOVERY, ORACLE DATABASE 11G PL/SQL PROGRAMMING WORKBOOK, OCA/OCP ORACLE DATABASE 11G ALL-IN-ONE EXAM GUIDE, MICROSOFT SQL SERVER 2008 ADMINISTRATION FOR ORACLE DBAS, ORACLE DATABASE ADMINISTRATION FOR SQL SERVER DBAS, ORACLE STREAMS 11G DATA REPLICATION, ORACLE DATABASE 11G RELEASE 2 HIGH AVAILABILITY, MAXIMIZE YOUR AVAILABILITY WITH GRID INFRASTRUCTURE, RAC AND DATA GUARD, ORACLE REAL APPLICATION CLUSTERS TESTING AND TUNING, OCP, ORACLE CRM ON DEMAND REPORTING, PEOPLESOFT DEVELOPER'S GUIDE FOR PEOPLETOOLS & PEOPLECODE, ORACLE E-BUSINESS SUITE FINANCIALS HANDBOOK, ORACLE E-BUSINESS SUITE MANUFACTURING & SUPPLY CHAIN MANAGEMENT, EFFECTIVE ORACLE BY DESIGN, ENTERPRISE GRID COMPUTING WITH ORACLE, ORACLE APPLICATION SERVER PORTAL HANDBOOK, ORACLE DATABASE 10G HIGH AVAILABILITY WITH RAC, FLASHBACK & DATA GUARD, ORACLE COLLABORATION SUITE HANDBOOK, ORACLE DATABASE 10G RMAN BACKUP & RECOVERY, ORACLE ENTERPRISE MANAGER 10G GRID CONTROL IMPLEMENTATION GUIDE, ORACLE E-BUSINESS SUITE SECURITY, TRANSFORMING INFOGLUT!, ORACLE CRM ON DEMAND REPORTING, ORACLE AUTOMATIC STORAGE MANAGEMENT, ORACLE DATABASE 11G DATA GUARD HANDBOOK, ORACLE GENERAL LEDGER GUIDE, ORACLE PROCURE-TO-PAY GUIDE, ORACLE ESSBASE & ORACLE OLAP, ORACLE DISCOVERER 10G HANDBOOK, ORACLE ENTERPRISE MANAGER 10G GRID CONTROL HANDBOOK, ORACLE FUSION DEVELOPER GUIDE, ORACLE E-BUSINESS SUITE DEVELOPMENT & EXTENSIBILITY HANDBOOK, ORACLE SOA SUITE 11G HANDBOOK, ORACLE WEBCENTER 11G HANDBOOK, ORACLE CRM ON DEMAND DEPLOYMENT GUIDE, PEOPLESOFT PEOPLETOOLS TIPS & TECHNIQUES, ORACLE CRM ON DEMAND DASHBOARDS, DESIGNING AN IAM FRAMEWORK WITH ORACLE IDENTITY AND ACCESS MANAGEMENT SUITE, QUICK START GUIDE TO ORACLE FUSION DEVELOPMENT, ORACLE CRM ON DEMAND COMBINED ANALYSES, ORACLE CRM ON DEMAND EMBEDDED ANALYTICS, MANAGING ORACLE FUSION APPLICATIONS, ORACLE FUSION MIDDLEWARE 11G ARCHITECTURE AND MANAGEMENT, ORACLE DATABASE 11G BUILDING XML APPLICATIONS, ORACLE DATABASE 11G REAL APPLICATION CLUSTERS HANDBOOK, ORACLE BPM SUITE 11G HANDBOOK, ORACLE VM IMPLEMENTATION AND ADMINISTRATION GUIDE, ORACLE WEBLOGIC SERVER 11G ADMINISTRATION HANDBOOK, ORACLE HYPERION FINANCIAL MANAGEMENT TIPS AND TECHNIQUES, SQL DEMYSTIFIED, SQL A BEGINNER'S GUIDE, SQL THE COMPLETE REFERENCE, ORACLE DATABASE 11G SQL, EFFECTIVE MYSQL BACKUP AND RECOVERY, ORACLE JDEVELOPER 11G HANDBOOK, ORACLE JDEVELOPER 10G FOR FORMS & PL/SQL DEVELOPERS, ORACLE DATABASE 10G EXPRESS EDITION PHP WEB PROGRAMMING, ORACLE DATABASE 11G PL/SQL PROGRAMMING, ORACLE DATABASE 11G SQL, ORACLE DATABASE AJAX & PHP WEB APPLICATION DEVELOPMENT, ORACLE SQL DEVELOPER HANDBOOK, ORACLE APPLICATION SERVER 10G WEB DEVELOPMENT, ORACLE HTML DB HANDBOOK