Difference between revisions of "MySQL Backup and Recovery"

From The Open Source Backup Wiki (Amanda, MySQL Backup, BackupPC)
Jump to navigationJump to search
Line 47: Line 47:
 
</td><td rowspan="2" valign="top" style="width: 55%; border: 1px solid gray; padding-left:1em; font-size: 95%">
 
</td><td rowspan="2" valign="top" style="width: 55%; border: 1px solid gray; padding-left:1em; font-size: 95%">
 
== Releases ==
 
== Releases ==
* [http://www.zmanda.com/download-zrm.php Release 2.1 beta]
+
* [http://www.zmanda.com/download-zrm.php Release 2.1 (Dec 9, '08)]
 
** Support for storage snapshots as backups
 
** Support for storage snapshots as backups
 
** Converting storage snapshots into regular backups
 
** Converting storage snapshots into regular backups

Revision as of 22:36, 9 December 2008

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

Presentations/White papers

Websites

Releases

  • Release 2.1 (Dec 9, '08)
    • Support for storage snapshots as backups
    • Converting storage snapshots into regular backups
    • Support for MySQL 5.1GA
  • 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.