Difference between revisions of "MySQL Backup and Recovery"
From The Open Source Backup Wiki (Amanda, MySQL Backup, BackupPC)
Jump to navigationJump to search(18 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
__NOEDITSECTION__ __NOTOC__ | __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. | |
− | 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 | * 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 | ||
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"> | <table style="width: 100%;" cellspacing="5"> | ||
Line 19: | Line 20: | ||
== Documentation == | == Documentation == | ||
− | * [[Zmanda Recovery Manager for MySQL Users Manual]] | + | * [[Zmanda Recovery Manager for MySQL Users Manual]] |
− | |||
* [[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 | + | * [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 | + | * [[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://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] | ||
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%"> | ||
− | |||
== Releases == | == Releases == | ||
− | * [http://www.zmanda.com/download-zrm.php Release | + | * [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 | |
− | * [http://www.zmanda.com/download-zrm.php Release | + | ** 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 | |
− | ** Support for | + | ** ZRM clients for Linux (RPM/Debian) and Solaris |
− | ** | + | ** Tested on Gentoo distribution |
− | + | ** Improved Snapshot interface | |
− | * [http://www.zmanda.com/download-zrm.php Release | + | ** Solaris ZFS snapshot plugin |
− | ** Support for | + | ** Backup of remote servers using snapshots |
− | ** | + | ** Asychronous checksum calculations |
− | + | ** Backup compression on the fly for logical backups | |
− | |||
− | |||
− | ** Support for MySQL | ||
− | |||
− | * [http://www.zmanda.com/download-zrm.php Release | ||
− | |||
− | |||
− | |||
− | ** | ||
− | ** | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | ** | ||
− | ** | ||
− | * | ||
− | * | ||
− | ** | ||
− | ** | ||
− | |||
− | ** | ||
− | |||
</td> | </td> | ||
</tr> | </tr> | ||
</table> | </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
|