Difference between revisions of "MySQL Backup and Recovery"

From The Open Source Backup Wiki (Amanda, MySQL Backup, BackupPC)
Jump to navigationJump to search
 
(28 intermediate revisions by 5 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, 1.1.4 and 1.1.5
+
* [[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 ==
+
== 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]]
== White papers ==
+
* [[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/blogs/?p=19 Comparison of MySQL database backup methods]
  
== Releases ==
+
== Websites ==
* [http://www.zmanda.com/downloads.html 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/downloads.html 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/downloads.html 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/downloads.html Release 1.1.2 (November 21, '06)]
 
** Debian packaging
 
** Support for MySQL 4.0.24
 
** Bug fixes
 
* [http://www.zmanda.com/downloads.html Release 1.1.1 (November 2, '06)]
 
** FHS compliance
 
** Bug fixes
 
* [http://www.zmanda.com/downloads.html 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/downloads.html Release 1.0.3 (September 22, '06)]
 
** HTML reports
 
** Bug fixes
 
* [http://www.zmanda.com/downloads.html 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/downloads.html 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/downloads.html Release 1.0 (August 31, '06)]
 
** Initial release with support for MySQL server backup, recovery, scheduling and reporting.
 
 
 
== 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 80: 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