Difference between revisions of "MySQL Backup and Recovery"
From The Open Source Backup Wiki (Amanda, MySQL Backup, BackupPC)
Jump to navigationJump to search(41 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 56: | 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
|