1

We have an option to do recovery through bin-logs, but we thought recovery through bin-logs is not 99% consistent because there is no LSN(Log Sequence Number)/SCN (System Change Number) in bin-logs (Statement/mixed/row).

Is there any possibility to archive innodb-redo-logs ?

Is there any chance to do recovery by using archived Innodb Redo-logs (at the time of instance start-up) ?

Looking for valuable suggestions.

Note: I'm searching for oracle style recovery in MySQL.

Thank you all :)

  • MySQL is different than Oracle. Look for tools tuned for MySQL; the best ones may not follow the pattern you are used to. – Rick James Dec 24 '15 at 15:54
1

Not sure if this the answer you are looking for but Percona Server has a Log Archiving for XtraDB feature and you can restore a backup to a specific point in time by specifying an LSN.

Just be aware of this note from the documentation:

This feature implementation is considered BETA quality.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.