MySQL Backup and Recovery: Difference between revisions

From wiki.zmanda.com
Jump to navigation Jump to search
No edit summary
No edit summary
 
(5 intermediate revisions by the same user not shown)
Line 9: Line 9:
* Verify your backup images
* Verify your backup images
* Compress and encrypt your backup images
* Compress and encrypt your backup images
* Implement Site or [http://www.rushessay.org rushessays] Application specific backup policies
* Implement Site or Application specific backup policies
* 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
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 2.2 Beta]
* [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 pre-restore and post-restore plugins
** Support for mixed replication mode binary logs
** Support for mixed replication mode binary logs
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