MySQL Backup and Recovery

From The Open Source Backup Wiki (Amanda, MySQL Backup, BackupPC)
Revision as of 22:10, 26 November 2008 by Paddy (talk | contribs)
Jump to navigationJump to search

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 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.