Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What would you suggest as a replacement system to achieve the same functionality of Oracle Flashback Archive aka Total Recall in other DBMS, in general or specifically in MySQL or MariaDB?


  • Not changing too much in the target database, like creating triggers for all tables.
  • Can't affect target performance. Ok, maybe a little...
  • Follow target schema changes

This system can be something to develop or something already made (free or commercial).

I can imagine something using MySQL binary logs to achieve this but at the same time this idea is blocking any other ideas. Do you have any good ones?


migration rejected from Jun 22 '15 at 20:24

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Colin 't Hart, RolandoMySQLDBA, Paul White, RLF, dezso Jun 22 '15 at 20:24

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Colin 't Hart, RolandoMySQLDBA, Paul White, RLF, dezso
If this question can be reworded to fit the rules in the help center, please edit the question.

The Oracle Flashback features mostly use data from the Undo tablespace (Flashback Archive aka Total Recall uses history tables and Flashback Drop uses the Oracle recycle bin). Then there's the extensions to the SQL syntax (FLASHBACK TABLE, SELECT ... AS OF, etc ). So first of all you need to define which features of Flashback you really want. – APC Jan 26 '12 at 14:36
Thanks APC, I've edit my question being more specific – rsilva4 Jan 26 '12 at 14:55