Effective MySQL Backup and Recovery

Effective MySQL Backup and Recovery

4.11 - 1251 ratings - Source

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 optionsThis is expected: 120408 2:12:04 InnoDB: Initializing buffer pool, size = 4.96 120408 2:12:05 InnoDB: Completed initialization of buffer pool ... sockI port: 3306 (Ubuntu) CAUTION The current MEB version 3.7 .0 requires the specification of the innodb - l og- fi 1 es - in -group ... If this is not defined in your MySQL installation, this must be specified on the command line. ... (Errcode: 13) mysqlbackup: ERROR: Could not create directory for server repository; Creation of datadir failed.

Title:Effective MySQL Backup and Recovery
Author:Ronald Bradford
Publisher:McGraw Hill Professional - 2012-06-19


You Must CONTINUE and create a free account to access unlimited downloads & streaming