Re: MySQL Enterprise Backup
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.
Subject
Views
Written By
Posted
2901
March 09, 2015 07:53AM
Re: MySQL Enterprise Backup
1666
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.