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

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

        Details

        • Type: Bug
        • Status: Confirmed
        • Priority: Major
        • Resolution: Unresolved
        • Affects Version/s: 10.0.10
        • Fix Version/s: 10.1
        • Component/s: None

          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.

            Gliffy Diagrams

              Attachments

                Issue Links

                is part of

                Task - A task that needs to be done. MDEV-4784 merge test cases from 5.6

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Stalled

                  Activity

                  Hide
                  Permalink
                  colin Colin Charles added a comment -

                  This is now documented here:
                  http://dev.mysql.com/doc/refman/5.6/en/mysqlbinlog-backup.html

                  This is in use by tools like MHA now as well: https://code.google.com/p/mysql-master-ha/wiki/Configuration#Binlog_server

                  Show
                  colin Colin Charles added a comment - This is now documented here: http://dev.mysql.com/doc/refman/5.6/en/mysqlbinlog-backup.html This is in use by tools like MHA now as well: https://code.google.com/p/mysql-master-ha/wiki/Configuration#Binlog_server

                    People

                    • Assignee:
                      ratzpo Rasmus Johansson
                      Reporter:
                      svoj Sergey Vojtovich
                    • Votes:
                      2 Vote for this issue
                      Watchers:
                      5 Start watching this issue

                      Dates

                      • Created:
                        Updated: