MySQL Backup and Recovery: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| (39 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. | |||
* 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]] | * [[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 == | |||
* [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: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:// | * [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/ | * [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] | |||
== | == Websites == | ||
* [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 60: | 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
|