Table of contents
The Zmanda Recovery Manager for MySQL (ZRM for MySQL) provides an intelligent and easy-to-configure framework for backing up and restoring MySQL Databases.
Optimize Backup and Restore Capabilities
ZRM for MySQL optimizes backup and restore operations on MySQL Databases. It provides full flexibility to individually leverage native MySQL/OS backup tools, levels, scheduling etc. It generates logs that assist in optimizing these capabilities. It also provides filters to easily locate anomalous database events.
Backup Features
- Backs up multiple MySQL databases managed by one or more MySQL servers.
- Backs up tables in a single database.
- Supports hot backup.
- Supports multiple backup methods, depending on the storage engine used by MySQL tables.
- Full and incremental database backups.
- Supports use of mysqldump, mysqlhotcopy, lvm snapshots and MySQL replication to execute backups.
- Creates consistent backups of the database regardless of the storage engine used by database tables.
- Supports SSL authentication between the local ZRM for MySQL and remote MySQL server to allow secure backups over the Internet and across firewalls.
- Verifies backed up data images.
- Backup images can be compressed as well as encrypted using standard tools such as gzip, GPG, etc .
- Backup runs can be cancelled by users with Administrative privileges.
Recovery Features
- Optionally maintain a backup index that stores information about each backup run.
- Includes a {{web.html($Report_method)}} that can be used to browse indexes.
- Supports recovery of full and incremental database backups.
- Perform selective, incremental restores based on binary log position, or by a given point in time, thus protecting the database from operator errors.
- Binary log filtering helps you decide what to restore and what to discard.
- Depending on the type of backups selected, data can be recovered to the same machine or to a different machine.
Reporting and Scheduling Capabilities
- ZRM for MySQL can schedule backup runs immediately or in daily/weekly/monthly intervals.
- It automatically generates backup reports.
- It has predefined backup reports as well as user defined backup reports.
- It can report any backup statistic or combination thereof.
- It can format reports as HTML or Text .
- It sends email notification about the backup run status.
- It can provide backup reports as RSS feed.
Plugins
ZRM for MySQL allows plugin operations to extend ZRM for MySQL capabilities. Plugins allow you to optimize the backup process for your environment. The following plugin operations are supported (see the Backup How page for detailed configuration information):
- Pre-scheduling
- Pre-backup
- Post-backup
- Copy plugins for Linux/Unix and Windows
- Binary log parser plugin
- Snapshot plugin