Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-1141

maxbinlogcheck to replace an event with ignorable event

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 2.2.0
    • binlogrouter
    • 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!

      Attachments

        Issue Links

          Activity

            People

              Massimiliano Pinto Massimiliano Pinto (Inactive)
              michaeldg Michaël de groot
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.