From: ewen fortune
Date: November 25 2008 7:57pm
Subject: Re: Mysql and Flashback
List-Archive: http://lists.mysql.com/mysql/215368
Message-Id: <17ed869f0811251157v40b145f0we0840edb0a61c3e7@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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 <smiley@stripped> 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/mysql?unsub=ewen.fortune@stripped
>
>