MySQL Backup and Recovery

Zmanda Recovery Manager (ZRM) for MySQL simplifies life of a database administrator who needs an easy to use yet flexible and robust backup and recovery solution for MySQL server.

With ZRM for MySQL you can:

• Schedule full and incremental logical or raw backups of your MySQL database
• Perform backup that is the best match for your storage engine and your MySQL configuration
• Get e-mail notification about status of your backups
• Monitor and obtain reports about your backups (including RSS feeds!!!)
• Verify your backup images
• Compress and encrypt your backup images
• Implement Site or Application specific backup policies
• Recover database easily to any point in time or to any particular database event
• Custom plugins to tailor MySQL backups to your environment

Documentation

• Zmanda Recovery Manager for MySQL Users Manual - Release 1.1.3-5 and Release 1.2
• Zmanda Recovery Manager for MySQL users manual - Release 1.1.2 and earlier versions
• Zmanda Recovery Manager for MySQL Man pages

Presentations

• Zmanda Recovery Manager for MySQL, Jan 17, 2007
• ZRM for MySQL: Vision and Roadmap, MySQL Users Conference, April 25, 2007

White papers

• MySQL ZRM how-to document for debian sarge distribution
• MySQL ZRM download info for debian sarge package for 1.0.3 version
• White paper on installing, configuring, backing up and restoring MySQL database in 15 minutes using ZRM for MySQL.
• What to consider when you back up a remote MySQL server over internet

Releases

• Release 1.2 (June, 25 '07)
  • Bug fixes
  • Code restructured into modules.
  • Snapshot plugin interface. LVM snapshots implemented as a plugin.
  • ZRM should be run as user belonging to mysql group.

(Migration command available for old backup configuration and images)

• Release 1.1.5 (March, 12 '07)
  • New restore options: --mysql-shutdown and --no-mysql-shutdown
  • Do automatic report generation only if html-report-dir is specified.
  • Fixed bugs
• Release 1.1.4 (January 30, '07)
  • Support for aborting backup runs
  • Support for character sets and stored routines
  • Bug fixes
• Release 1.1.3 (December 19, '06)
  • Support for Ubuntu and MySQL enterprise server
  • Configuration parameters read by the custom plugins
  • Bug fixes
• Release 1.1.2 (November 21, '06)
  • Debian packaging
  • Support for MySQL 4.0.24
  • Bug fixes
• Release 1.1.1 (November 2, '06)
  • FHS compliance
  • Bug fixes
• Release 1.1 (October 18, '06)
  • Backup compression and encryption
  • Custom plugins to tailor backups to user environment
  • Backup reports as RSS feeds
  • Automatic backup report generation after every backup run
  • Bug fixes
• Release 1.0.3 (September 22, '06)
  • HTML reports
  • Bug fixes
• Release 1.0.2 (September 14, '06)
  • Verification of backup images
  • Predefined backup reports and report formatting
  • Tools for selective restoration of database
  • Bug fixes
• Release 1.0.1 (September 07, '06)
  • Support for backup retention policy
  • Additional backup performance parameters - read-locks-time, flush-logs-time for comparing backup performance between backup runs and backup methods.
  • Various bug fixes
• Release 1.0 (August 31, '06)
  • Initial release with support for MySQL server backup, recovery, scheduling and reporting.

Other tools/scripts for MySQL backup

• mybackup.sh Script for exporting MySQL databases into a compressed file, so you can easily backup them later using amanda or any other kind of backup tool. Also it backups binary logs (if enabled) and configuration files. The script has a small configuration area so you can adapt it to your needs.

Note: You should never backup open database files. You won`t be able to restore them.

Other Links

• Zmanda Recovery Manager for MySQL home page
• Forums
• Subscribe to ZRM mailing lists
• ZRM users mailing list archive
• ZRM for MySQL Bugzilla
• Zmanda Recovery Manager copyright and license
• About this Wiki
• Licenses, Copyrights and Trademarks