Difference between revisions of "MySQL Backup and Recovery"

From The Open Source Backup Wiki (Amanda, MySQL Backup, BackupPC)
Jump to navigationJump to search
Line 1: Line 1:
 +
__NOEDITSECTION__ __NOTOC__
 +
 
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.  
 
With ZRM for MySQL you can:
 
  
 
* Schedule full and incremental logical or raw backups of your MySQL database
 
* Schedule full and incremental logical or raw backups of your MySQL database
 
* 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
 +
 +
<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 ==
Line 28: Line 32:
 
* [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]
 
* [http://www.zmanda.com/blogs/?p=19 Comparison of MySQL database backup methods]
 
* [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://forums.zmanda.com/ Forums]
 +
* [http://www.zmanda.com/mailing-lists.php Subscribe to ZRM mailing lists]
 +
* [http://forums.zmanda.com/pipermail/mysql-zrm-users/ ZRM users mailing list archive]
 +
* [http://forums.zmanda.com/bugzilla/ ZRM for MySQL Bugzilla]
 +
* [http://www.zmanda.com/zrm-mysql-community.html Zmanda Recovery Manager copyright and license]
 +
* [[About this Wiki]]
 +
* [[Licenses, Copyrights and Trademarks]]
 +
 +
</td><td rowspan="2" valign="top" style="width: 55%; border: 1px solid gray; padding-left:1em; font-size: 95%">
  
 
== Releases ==
 
== Releases ==
Line 79: Line 96:
 
** Initial release with support for MySQL server backup, recovery, scheduling and reporting.
 
** Initial release with support for MySQL server backup, recovery, scheduling and reporting.
  
== Other tools/scripts for MySQL backup ==
+
</td>
* [http://marc-muehlfeld.de/scripts/mybackup.sh mybackup.sh] Script for exporting MySQL databases into a compressed file, so you can easily backup them later using amanda or any other kind of backup tool. Also it backups binary logs (if enabled) and configuration files. The script has a small configuration area so you can adapt it to your needs.
+
</tr>
: ''Note: You should never backup open database files. You won`t be able to restore them.''
+
</table>
 
 
== Other Links ==
 
 
 
* [http://www.zmanda.com/backup-mysql.html Zmanda Recovery Manager for MySQL home page]
 
* [http://forums.zmanda.com/ Forums]
 
* [http://www.zmanda.com/mailing-lists.php Subscribe to ZRM mailing lists]
 
* [http://forums.zmanda.com/pipermail/mysql-zrm-users/ ZRM users mailing list archive]
 
* [http://forums.zmanda.com/bugzilla/ ZRM for MySQL Bugzilla]
 
* [http://www.zmanda.com/zrm-mysql-community.html Zmanda Recovery Manager copyright and license]
 
* [[About this Wiki]]
 
* [[Licenses, Copyrights and Trademarks]]
 

Revision as of 22:39, 16 October 2007


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
  • 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

Documentation

Presentations/White papers

Websites

Releases