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 Zmanda Recovery Manager for MySQL Man pages Zmanda Recovery Manager for MySQL users manual (OLD) Presentations/White papers White paper on installing, configuring, backing up and restoring MySQL database in 15 minutes using ZRM for MySQL ZRM documentation in Chinese Zmanda Recovery Manager for MySQL ZRM for MySQL: Vision and Roadmap, MySQL Users Conference MySQL ZRM how-to document for debian sarge distribution 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 3.0 Support for parallel logical backups using MyDumper Release 2.2 Support for pre-restore and post-restore plugins Support for mixed replication mode binary logs Support for producing html output after parsing binary logs Support for mail notification policy Added support for exclude pattern for databases and tables in the backup set Release 2.1.x Support for storage snapshots as backups Converting storage snapshots into regular backups Support for MySQL 5.1 Release 2.0 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