PDA

View Full Version : ZRM for MySQL version 1.0.2 released!!!



paddy
September 14th, 2006, 03:11 PM
Version 1.0.2 of Zmanda Recovery Manager (ZRM) for MySQL, a robust and intelligent solution for backup and recovery of MySQL databases. is available in Zmanda downloads (http://www.zmanda.com/downloads.html) page.

Version 1.0.2 changes

Verification of backup images
Predefined backup reports and report formatting
Tools for selective restoration of database
Bug fixes


For more information, see ZRM for MySQL (http://mysqlbackup.zmanda.com) wiki. Feedback on the software would be appreciated.

Paddy

bethany
September 22nd, 2006, 09:33 AM
Hi Paddy - does the backup user need SUPER rights in order to perform incremental backups?

paddy
September 22nd, 2006, 09:59 AM
Hi Bethany,

In 1.0.2, there is a bug that requires SUPER, REPLICATION CLIENT for incremental backups.

In 1.0.3 (which will be released today), the backup user will need SUPER privilege for incremental backups.

Thanks,
Paddy

bethany
September 22nd, 2006, 10:11 AM
Thanks! Also, are incremental backups only supported when running mysql-zrm on the machine local to the mysql databases? I'm trying to do an incremental backup of a different host, but the backups are failing because zrm is trying to copy the bin logs from the local filesystem rather than the remote one:

INFO: Getting list of binary logs using command mysql --user=dba-backup --password=***** --host=db.is.gatech.edu -e "show master logs"
INFO: cp -p "/var/lib/mysql/db-bin.000001" "/var/lib/mysql-zrm/db/20060922134922/db-bin.000001"
cp: cannot stat `/var/lib/mysql/db-bin.000001': No such file or directory
ERROR: Copy from /var/lib/mysql/db-bin.000001 to /var/lib/mysql-zrm/db/20060922134922/db-bin.000001 failed
ERROR: Could not copy bin log file db-bin.000001

etc...

paddy
September 22nd, 2006, 10:18 AM
Hi Bethany,

Incremental backups/restoration are supported only on local machine. We will
add remote support in a future release.

Paddy