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.

• Schedule full and incremental logical or raw backups of your MySQL database
• Centralized backup management
• 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
• Storage/filesystem snapshots as backups

Documentation Zmanda Recovery Manager for MySQL Users Manual - Updated for Release 2.0 Zmanda Recovery Manager for MySQL users manual (OLD) Zmanda Recovery Manager for MySQL Man pages - Updated for Release 2.1 Presentations/White papers Zmanda Recovery Manager for MySQL, Jan 17, 2007 ZRM for MySQL: Vision and Roadmap, MySQL Users Conference, April 25, 2007 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 Top 5 Considerations while setting up your MySQL Backup Comparison of MySQL database backup methods Websites 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

Releases Release 2.1 beta Support for storage snapshots as backups Converting storage snapshots into regular backups Release 2.0 (Apr 3, '08) Solaris packages ZRM clients for Linux (RPM/Debian) and Solaris Tested on Gentoo distribution Improved Snapshot interface Solaris ZFS snapshot plugin Backup of remote servers using snapshots Asychronous checksum calculations Backup compression on the fly for logical backups Release 1.2.1 (Sept, 14, '07) Source tar ball (including debian package files) Help from ZRM online sites Code restructured into modules. Snapshot plugin interface. LVM snapshots implemented as a plugin. ZRM should be run as n user belonging to the mysql group. 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. Support for aborting backup runs Support for character sets and stored routines Support for Ubuntu and MySQL enterprise server Configuration parameters read by the custom plugins Debian packaging Support for MySQL 4.0.24 FHS compliance 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 Release 1.0 (August 31, '06) Initial release with support for MySQL server backup, recovery, scheduling and reporting. HTML reports Verification of backup images Predefined backup reports and report formatting Tools for selective restoration of database 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.