MySQL Forums
Forum List  »  Backup

Re: MySQL Enterprise Backup
Posted by: David Horne
Date: May 14, 2015 12:53PM

Hey Mike, the enterprise backup documentation covers this pretty well. Compression forces your hand a little bit as to when you must apply the logs produced during the backup process.

1. Backup - basically copies the raw files to a destination. The files are not transactionally consistent. In this scenario you will have to run the apply log separately after doing the restore.

2. Backup and Apply Log - basically copies the raw files and then replays all transactions that happened during the backup, so that you have a transactionally consistent backup. In this scenario you can restore the files to another server without having to do anything else. However as you mentioned, this option is not available when doing compression.

Options: ReplyQuote

Written By
March 09, 2015 07:53AM
Re: MySQL Enterprise Backup
May 14, 2015 12:53PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.