Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5993

MySQL WL#4783 Extend mysqlbinlog to support remote backup of binary logs

    XMLWordPrintable

    Details

      Description

      main.mysqlbinlog_raw_mode and main.mysqlbinlog_raw_mode_win covering this worklog: https://dev.mysql.com/worklog/task/?id=4783

      MySQL needs a way of creating real-time backups.  The current method of doing
      this is to create a slave with using the blackhole engine as can be seen at the
      following URL:
      http://dev.mysql.com/doc/refman/5.1/en/blackhole-storage-engine.html
       
      This method works rather well but has the disadvantage of requiring a whole
      MySQL instance to run to make the real-time backups, this can be a burden on
      resources and difficult to setup if you are trying to backup many MySQL servers.
       
      We already have mysqlbinlog to talk to remote MySQL servers to retrieve binlog
      data and translate it into SQL statements so in theory it should be easy enough
      to create a raw mode for the output.
       
      Solution
      mysqlbinlog has been modified to have several new parameters, key to this is the
      new --raw flag which writes the data out in raw binlog format rather than
      translating it.  The other parameter changes are designed to add more
      functionality to the --raw flag so that it can easily be used in various backup
      scenarios.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              holyfoot Alexey Botchkov
              Reporter:
              svoj Sergey Vojtovich
              Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: