MySQL Backup and Recovery: Difference between revisions

From wiki.zmanda.com
Jump to navigation Jump to search
No edit summary
No edit summary
Line 3: Line 3:


* Schedule full and incremental logical or raw backups of your MySQL database
* 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
* Perform backup that is the best match for your storage engine and your MySQL configuration
* Get e-mail notification about status of your backups
* Get e-mail notification about status of your backups
Line 18: Line 19:
== Documentation ==
== Documentation ==


* [[Zmanda Recovery Manager for MySQL Users Manual]] - Release 1.1.3-5 and Release 1.2.X
* [[Zmanda Recovery Manager for MySQL Users Manual]] - Updated for Release 2.0
* [[Zmanda Recovery Manager for MySQL]] users manual - Release 1.1.2 and earlier versions
* [[Zmanda Recovery Manager for MySQL]] users manual (OLD)
* [[Zmanda Recovery Manager for MySQL Man pages]]
* [[Zmanda Recovery Manager for MySQL Man pages]] - Updated for Release 2.0


== Presentations/White papers ==
== Presentations/White papers ==
Line 45: Line 46:
</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.0 (Apr 3, '07)]
** 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
* [http://www.zmanda.com/download-zrm.php Release 1.2.1 (Sept, 14, '07)]
* [http://www.zmanda.com/download-zrm.php Release 1.2.1 (Sept, 14, '07)]
** Source tar ball (including debian package files)
** Source tar ball (including debian package files)
** Help from ZRM online sites
** Help from ZRM online sites
* [http://www.zmanda.com/download-zrm.php Release 1.2 (June, 25 '07)]
** Code restructured into modules.
** Code restructured into modules.
** Snapshot plugin interface. LVM snapshots implemented as a plugin.
** Snapshot plugin interface. LVM snapshots implemented as a plugin.
Line 55: Line 64:
** New restore options: --mysql-shutdown and --no-mysql-shutdown
** New restore options: --mysql-shutdown and --no-mysql-shutdown
** Do automatic report generation only if html-report-dir is specified.
** Do automatic report generation only if html-report-dir is specified.
* [http://www.zmanda.com/download-zrm.php Release 1.1.4 (January 30, '07)]
** Support for aborting backup runs
** Support for aborting backup runs
** Support for character sets and stored routines
** Support for character sets and stored routines
* [http://www.zmanda.com/download-zrm.php Release 1.1.3 (December 19, '06)]
** Support for Ubuntu and MySQL enterprise server
** Support for Ubuntu and MySQL enterprise server
** Configuration parameters read by the custom plugins
** Configuration parameters read by the custom plugins
* [http://www.zmanda.com/download-zrm.php Release 1.1.2 (November 21, '06)]
** Debian packaging
** Debian packaging
** Support for MySQL 4.0.24
** Support for MySQL 4.0.24
* [http://www.zmanda.com/download-zrm.php Release 1.1.1 (November 2, '06)]
** FHS compliance
** FHS compliance
* [http://www.zmanda.com/download-zrm.php Release 1.1 (October 18, '06)]
** Backup compression and encryption
** Backup compression and encryption
** Custom plugins to tailor backups to user environment
** Custom plugins to tailor backups to user environment
Line 73: Line 77:
* [http://www.zmanda.com/download-zrm.php Release 1.0.3 (September 22, '06)]
* [http://www.zmanda.com/download-zrm.php Release 1.0.3 (September 22, '06)]
** HTML reports
** HTML reports
* [http://www.zmanda.com/download-zrm.php Release 1.0.2 (September 14, '06)]
** Verification of backup images
** Verification of backup images
** Predefined backup reports and report formatting
** Predefined backup reports and report formatting
** Tools for selective restoration of database
** Tools for selective restoration of database
* [http://www.zmanda.com/download-zrm.php Release 1.0.1 (September 07, '06)]
** Support for backup retention policy
** 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.
** Additional backup performance parameters - ''read-locks-time'', ''flush-logs-time'' for comparing backup performance between backup runs and backup methods.

Revision as of 19:10, 3 April 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

Documentation

Presentations/White papers

Websites

Releases

  • Release 2.0 (Apr 3, '07)
    • 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.3 (September 22, '06)
    • 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.
  • Release 1.0 (August 31, '06)
    • Initial release with support for MySQL server backup, recovery, scheduling and reporting.