Take the 2-minute tour ×
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.

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?

Requirements:

  • 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?

Thanks in advance.

share|improve this question
1  
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 –  rsilva Jan 26 '12 at 14:55
add comment

migrated from stackoverflow.com Jan 26 '12 at 11:57

This question came from our site for professional and enthusiast programmers.

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.