Difference between revisions of "MySQL Backup and Recovery"

From The Open Source Backup Wiki (Amanda, MySQL Backup, BackupPC)
Jump to navigationJump to search
 
(19 intermediate revisions by 3 users not shown)
Line 1: Line 1:
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.  
+
__NOEDITSECTION__ __NOTOC__
 
+
[http://www.zmanda.com/backup-mysql.html 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
 
* 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
* Monitor and obtain reports about your backups (including RSS feeds!!!)
+
* Monitor and obtain reports about your backups (including RSS feeds)
 
* Verify your backup images
 
* Verify your backup images
 
* Compress and encrypt your backup images
 
* Compress and encrypt your backup images
Line 12: Line 12:
 
* Recover database easily to any point in time or to any particular database event
 
* Recover database easily to any point in time or to any particular database event
 
* Custom plugins to tailor MySQL backups to your environment
 
* Custom plugins to tailor MySQL backups to your environment
 +
* Storage/filesystem snapshots as backups
 +
 +
<table style="width: 100%;" cellspacing="5">
 +
<!-- Full-width header text -->
 +
<tr><td valign="top" style="width: 45%; border: 1px solid gray; padding-left:1em; font-size: 95%">
  
 
== 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]]  
* [[Zmanda Recovery Manager for MySQL]] users manual - Release 1.1.2 and earlier versions
 
 
* [[Zmanda Recovery Manager for MySQL Man pages]]
 
* [[Zmanda Recovery Manager for MySQL Man pages]]
 +
* [[Zmanda Recovery Manager for MySQL]] users manual (OLD)
  
 
== Presentations/White papers ==
 
== Presentations/White papers ==
* [[Media:Webinar_Zmanda_Recovery_Manager_for_MySQL.pdf|Zmanda Recovery Manager for MySQL, Jan 17, 2007]]
+
* [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
* [[Media:ZRM_MySQL_users_conference.pdf|ZRM for MySQL: Vision and Roadmap, MySQL Users Conference, April 25, 2007]]
+
* [[Media:zrm4mysql_zh.pdf|ZRM documentation in Chinese]]
 +
* [[Media:Webinar_Zmanda_Recovery_Manager_for_MySQL.pdf|Zmanda Recovery Manager for MySQL]]
 +
* [[Media:ZRM_MySQL_users_conference.pdf|ZRM for MySQL: Vision and Roadmap, MySQL Users Conference]]
 
* [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 for debian sarge package for 1.0.3 version]
 
* [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.
 
 
* [http://www.zmanda.com/zrm-over-internet.html What to consider when you back up a remote MySQL server over internet]
 
* [http://www.zmanda.com/zrm-over-internet.html What to consider when you back up a remote MySQL server over internet]
 
* [http://www.zmanda.com/mysql-backup-considerations.html Top 5 Considerations while setting up your MySQL Backup]
 
* [http://www.zmanda.com/mysql-backup-considerations.html Top 5 Considerations while setting up your MySQL Backup]
 
* [http://www.zmanda.com/blogs/?p=19 Comparison of MySQL database backup methods]
 
* [http://www.zmanda.com/blogs/?p=19 Comparison of MySQL database backup methods]
  
== Releases ==
+
== Websites ==
* [http://www.zmanda.com/download-zrm.php Release 1.2.1 (Sept, 14, '07)]
 
** Bug fixes
 
** Source tar ball (including debian package files)
 
** Help from ZRM online sites
 
* [http://www.zmanda.com/download-zrm.php Release 1.2 (June, 25 '07)]
 
** Bug fixes
 
** 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.
 
* [http://www.zmanda.com/download-zrm.php 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.
 
** Fixed bugs
 
* [http://www.zmanda.com/download-zrm.php Release 1.1.4 (January 30, '07)]
 
** Support for aborting backup runs
 
** Support for character sets and stored routines
 
** Bug fixes
 
* [http://www.zmanda.com/download-zrm.php Release 1.1.3 (December 19, '06)]
 
** Support for Ubuntu and MySQL enterprise server
 
** Configuration parameters read by the custom plugins
 
** Bug fixes
 
* [http://www.zmanda.com/download-zrm.php Release 1.1.2 (November 21, '06)]
 
** Debian packaging
 
** Support for MySQL 4.0.24
 
** Bug fixes
 
* [http://www.zmanda.com/download-zrm.php Release 1.1.1 (November 2, '06)]
 
** FHS compliance
 
** Bug fixes
 
* [http://www.zmanda.com/download-zrm.php 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
 
* [http://www.zmanda.com/download-zrm.php Release 1.0.3 (September 22, '06)]
 
** HTML reports
 
** Bug fixes
 
* [http://www.zmanda.com/download-zrm.php 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
 
* [http://www.zmanda.com/download-zrm.php 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
 
* [http://www.zmanda.com/download-zrm.php Release 1.0 (August 31, '06)]
 
** Initial release with support for MySQL server backup, recovery, scheduling and reporting.
 
 
 
== Other tools/scripts for MySQL backup ==
 
* [http://marc-muehlfeld.de/scripts/mybackup.sh mybackup.sh] Script for exporting MySQL databases into a compressed file, so you can easily backup them later using amanda or any other kind of backup tool. Also it backups binary logs (if enabled) and configuration files. The script has a small configuration area so you can adapt it to your needs.
 
: ''Note: You should never backup open database files. You won`t be able to restore them.''
 
 
 
== Other Links ==
 
  
 
* [http://www.zmanda.com/backup-mysql.html Zmanda Recovery Manager for MySQL home page]
 
* [http://www.zmanda.com/backup-mysql.html Zmanda Recovery Manager for MySQL home page]
Line 93: Line 44:
 
* [[About this Wiki]]
 
* [[About this Wiki]]
 
* [[Licenses, Copyrights and Trademarks]]
 
* [[Licenses, Copyrights and Trademarks]]
 +
 +
</td><td rowspan="2" valign="top" style="width: 55%; border: 1px solid gray; padding-left:1em; font-size: 95%">
 +
== Releases ==
 +
* [http://www.zmanda.com/download-zrm.php Release 3.0]
 +
** Support for parallel logical backups using MyDumper
 +
* [http://www.zmanda.com/download-zrm.php 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
 +
* [http://www.zmanda.com/download-zrm.php Release 2.1.x]
 +
** Support for storage snapshots as backups
 +
** Converting storage snapshots into regular backups
 +
** Support for MySQL 5.1
 +
* [http://www.zmanda.com/download-zrm.php 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
 +
</td>
 +
</tr>
 +
</table>

Latest revision as of 19:26, 28 August 2013

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