PDA

View Full Version : complete point in time recovery.



ananda
June 5th, 2007, 09:40 PM
Hi All,
I have only tested the Zmanda backup and recovery in 15 Min using this url
http://www.zmanda.com/quick-mysql-backup.html.

This was basically a bump backup and restore method.

Does Zmanda does not provide auto restore/recovery till the point of failure based on the bin-logs.

Also, please provide you feedback if we can use this software for our database which runs 24/7.

regards
anandkl

kkg
June 5th, 2007, 09:48 PM
Hi All,
I have only tested the Zmanda backup and recovery in 15 Min using this url
http://www.zmanda.com/quick-mysql-backup.html.

This was basically a bump backup and restore method.

Does Zmanda does not provide auto restore/recovery till the point of failure based on the bin-logs.

Also, please provide you feedback if we can use this software for our database which runs 24/7.

regards
anandkl

Hi,

You can do the restore in a 3 step process as of today. These steps are

a) First do the restore from the full backup
b) Restart mysql server if needed
c) Restore all of the binary logs at one go using the --bin-logs, the --start-datetime and/or stop-datetime options.

ZRM is meant for backup of live databases so I think you should be able to use ZRM for your needs..

ananda
June 5th, 2007, 10:41 PM
Hi,
Should i use the mysqlbinlog command to do the restore or does zmanda provides any utility for this.

Sorry to ask these questions as i am a first time user and reading the doc as i type this.

regards
anandkl

kkg
June 5th, 2007, 10:44 PM
Hi,
Should i use the mysqlbinlog command to do the restore or does zmanda provides any utility for this.

Sorry to ask these questions as i am a first time user and reading the doc as i type this.

regards
anandkl

you can use mysql-zrm --action restore

--kkg