Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
2017-28
Description
Hi,
MaxScale binlog server is a great tool for point in time recovery. We use maxscale to continuously copy the binlogs to another machine.
Let's say a disaster occurs, somebody executes DROP TABLE databse.table;
We could do point in time recovery by restoring a backup and making the backup slave to MaxScale. It would replicate and replicate the disaster as well.
It would be great if we can nullify the event (make it ignorable by the replication slave). This way, we can remove the DROP TABLE from the binlog file and replicate all other events from MaxScale.
For example --remove-event=start_pos to remove the even from start_pos until the end of the event.
Thank you!