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

Add continuous binary log backup to mysqlbinlog

Details

    • 10.2.0-1, 10.2.0-5, 10.2.0-6

    Description

      This is a request to add continuous binary log backup to mysqlbinlog, such as exists in the MySQL mysqlbinlog as of 5.6.

      "As of MySQL 5.6, mysqlbinlog can read binary log files and write new files containing the same content—that is, in binary format rather than text format. This capability enables you to easily back up a binary log in its original format. mysqlbinlog can make a static backup, backing up a set of log files and stopping when the end of the last file is reached. It can also make a continuous (“live”) backup, staying connected to the server when it reaches the end of the last log file and continuing to copy new events as they are generated. In continuous-backup operation, mysqlbinlog runs until the connection ends (for example, when the server exits) or mysqlbinlog is forcibly terminated. When the connection ends, mysqlbinlog does not wait and retry the connection, unlike a slave replication server. To continue a live backup after the server has been restarted, you must also restart mysqlbinlog."

      https://dev.mysql.com/doc/refman/5.6/en/mysqlbinlog-backup.html

      This also requires the addition of 2 new mysqlbinlog options:

      --stop-never
      --stop-never-slave-server-id=id

      https://dev.mysql.com/doc/refman/5.6/en/mysqlbinlog.html#option_mysqlbinlog_stop-never
      https://dev.mysql.com/doc/refman/5.6/en/mysqlbinlog.html#option_mysqlbinlog_stop-never-slave-server-id

      Attachments

        Issue Links

          Activity

            holyfoot Alexey Botchkov added a comment - Patch proposal v2: http://lists.askmonty.org/pipermail/commits/2016-February/009051.html

            ok to push

            serg Sergei Golubchik added a comment - ok to push

            Are the only real changes here to mysqlbinlong.cc?

            If so, can this be backported to a GA version, say 10.1, and/or even 10.0?

            ccalender Chris Calender (Inactive) added a comment - Are the only real changes here to mysqlbinlong.cc? If so, can this be backported to a GA version, say 10.1, and/or even 10.0?

            Many thanks for adding this, btw!

            ccalender Chris Calender (Inactive) added a comment - Many thanks for adding this, btw!

            Chris,
            from the technical point of view yes, it can be backported to 10.0.

            holyfoot Alexey Botchkov added a comment - Chris, from the technical point of view yes, it can be backported to 10.0.

            People

              holyfoot Alexey Botchkov
              ccalender Chris Calender (Inactive)
              Votes:
              6 Vote for this issue
              Watchers:
              11 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.