Hi Shain, If you are using InnoDB its possible to patch to allow this functionality.
Percona are in the early stages of developing a patch specifically to allow flashback type access to previous table states. https://bugs.launchpad.net/percona-patches/+bug/301925 If you wanted to go down the slave lag road, Maatkit has a tool for doing that. http://www.maatkit.org/doc/mk-slave-delay.html Cheers, Ewen On Tue, Nov 25, 2008 at 6:57 PM, Shain Miley <[EMAIL PROTECTED]> wrote: > Hello, > We are planning on trying to do an Oracle to MySQL migration in the near > future. The issue of a Mysql equivalent to Oracle's flashback was being > discussed. After some digging it appears that there is no such feature in > Mysql. One thought that I had was to do some intentional replication lag > (say 12 to 24 hours)...that way if we needed to revert back we would have > the option of doing so. > > Does anyone: > > a: know how to setup a replication to intentionally lag? > > b: know of a better way of engineering a flashback equivalent for Mysql? > > Thanks in advance, > > Shain > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
