Difference between revisions of "MySQL Backup and Recovery"

From The Open Source Backup Wiki (Amanda, MySQL Backup, BackupPC)
Jump to navigationJump to search
Line 17: Line 17:
 
* [http://www.howtoforge.com/mysql_zrm_debian_sarge MySQL ZRM how-to document for debian sarge distribution]
 
* [http://www.howtoforge.com/mysql_zrm_debian_sarge MySQL ZRM how-to document for debian sarge distribution]
 
* [http://debian.systs.org/linux/91/mysql-zrm-103-1dso1-initial-release/ MySQL ZRM download info about precreated debian sarge package]
 
* [http://debian.systs.org/linux/91/mysql-zrm-103-1dso1-initial-release/ MySQL ZRM download info about precreated debian sarge package]
 +
* [http://www.zmanda.com/quick-mysql-backup.html White paper] on installing, configuring, backing up and restoring MySQL database in 15 minutes using ZRM for MySQL.
  
 
== Releases ==
 
== Releases ==

Revision as of 19:14, 29 October 2006

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

Releases

  • 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 Links