Zmanda Recovery Manager for MySQL Users Manual

Copyright 2005-2010 Zmanda Inc.

Table of Contents

Preface

1. Introduction
   1. Capabilities of ZRM for MySQL
2. Installation
   1. Tested Platforms
   2. Pre-Installation
   3. Download
   4. Install
   5. File Locations
   6. Perl Installation Notes
3. Backup Sets
   1. Configuration Files
   2. Backup Set Parameters
      1. Default Values
   3. Example Configuration
   4. Sample mysql-zrm.conf
4. Plugins
5. Backup
   1. What to Backup
   2. How to Backup
   3. Where to Backup
   4. Checking Backup Configuration
   5. When to Backup
      1. Backup Now
      2. Daily/ Weekly/ Monthly Schedules
      3. Delaying A Backup Run
   6. Verifying Backups
   7. Compression
   8. Encryption
   9. Extracting a Compressed Backup
   10. Aborting Backups
   11. Retention Policies
       1. Purging Backups
   12. Backup Plugins
       1. Pre Backup Plugin
       2. Post Backup Plugin
       3. Copy Plugin
       4. Snapshot Plugin
   13. Backup of Remote Servers
   14. Backup of MySQL Replication Slaves
   15. Backup of MySQL Databases on Logical Volumes
   16. Backup of MySQL Databases on Solaris ZFS
6. Backup Reports
   1. Pre-defined Reports
   2. User Defined Reports
   3. Formatting Reports
   4. Email/RSS Feed of Reports
   5. Listing Backups
7. Recovery
   1. Complete Restoration of Full & Incremental Backups
   2. Selective Recovery
      1. Binary Log Parser Plugin
   3. Restoring To An Alternate Location
   4. Verifying Restoration
8. Logs
9. Optimizations
10. Quick Start Example
11. Quick Start Example - Ubuntu Configuration
12. Quick Start Example - Open Solaris/ZFS snapshots
13. Quick Start Example - Backup/Recovery of partitioned tables