Difference between revisions of "MySQL Backup and Recovery"

From The Open Source Backup Wiki (Amanda, MySQL Backup, BackupPC)
Jump to navigationJump to search
 
(3 intermediate revisions by the same user not shown)
Line 20: Line 20:
 
== Documentation ==
 
== Documentation ==
  
* [[Zmanda Recovery Manager for MySQL Users Manual]] Release 2.2
+
* [[Zmanda Recovery Manager for MySQL Users Manual]]  
* [[Zmanda Recovery Manager for MySQL Man pages]] Release 2.2
+
* [[Zmanda Recovery Manager for MySQL Man pages]]
 
* [[Zmanda Recovery Manager for MySQL]] users manual (OLD)
 
* [[Zmanda Recovery Manager for MySQL]] users manual (OLD)
  
 
== Presentations/White papers ==
 
== Presentations/White papers ==
 
* [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/quick-mysql-backup.html White paper] on installing, configuring, backing up and restoring MySQL database in 15 minutes using ZRM for MySQL  
* [[Media:Webinar_Zmanda_Recovery_Manager_for_MySQL.pdf|Zmanda Recovery Manager for MySQL, Jan 17, 2007]]
+
* [[Media:zrm4mysql_zh.pdf|ZRM documentation in Chinese]]
* [[Media:ZRM_MySQL_users_conference.pdf|ZRM for MySQL: Vision and Roadmap, MySQL Users Conference, April 25, 2007]]
+
* [[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://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]
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%">
== Recent Releases ==
+
== 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]
 
* [http://www.zmanda.com/download-zrm.php Release 2.2]
 
** Support for pre-restore and post-restore plugins
 
** Support for pre-restore and post-restore plugins
Line 55: Line 58:
 
** Support for storage snapshots as backups
 
** Support for storage snapshots as backups
 
** Converting storage snapshots into regular backups
 
** Converting storage snapshots into regular backups
** Support for MySQL 5.1GA
+
** Support for MySQL 5.1
 
* [http://www.zmanda.com/download-zrm.php Release 2.0]
 
* [http://www.zmanda.com/download-zrm.php Release 2.0]
 
** Solaris packages
 
** Solaris packages

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