Xtrabackup 8.0.14 - MySQL 8.0.21 - Is possible backup redolog at last trasaction (as Oracle Manner)

Hi to all,
I wish to know what are steps to do to obtain a backup at last transaction?
I used this wonderful howto of DigitalOcean to generate a daily fullbackup and hourly incremental backup.
But how can must to do to have saved the data from last incremental backup (at min 01 of the hour) to now (e.g. min. 59 of the hour) ?
In other words if after a hardware disaster, Iwish replicate the DB on another machine what i must to do have the redo logs to go from last incremental backup to last commit?

Thanks

1 Like

To get the functionality you are asking you need also backup binary logs (this is separately from XtraBackup). And then you can replay binary logs since the last incremental backup

1 Like