Bug #65861 flashback from binlog for MySQL

• Submitted: 10 Jul 2012 5:49
• Modified: 10 Jul 2012 11:43
• Reporter: xiaobin lin (OCA)
• Status: Verified
• Category: MySQL Server: DML
• Severity: S4 (Feature request)
• Version: 5.*
• OS: Any
• CPU Architecture: Any
• Tags: Contribution, Flashback

[10 Jul 2012 5:49] xiaobin lin

Description:
There is a related feature request here. http://bugs.mysql.com/bug.php?id=65178

In order to make the flashback feature can handle DDL operation (such as truncate/drop table), we need to do some modification inside the server.

Simply we can bak the table that will be dropped to a bak_database. And record  the `flashback statement` into binary logs.

How to repeat:
new feature

Suggested fix:
The patch include the content in Plinux's patch, a slight modification is done for support DDL flashback.

[10 Jul 2012 6:20] xiaobin lin

Base on 5.5.18

Attachment: 5.5.18_flashback_all.patch (application/octet-stream, text), 36.26 KiB.