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 :)