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

Extend RESET MASTER to allow specifying next binary log.

    Details

    • Type: Task
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Fix Version/s: 10.1.6
    • Component/s: Replication
    • Labels:
      None

      Description

      Hi,

      I would like the "RESET MASTER" command to be extended to the following:

      RESET MASTER [AT file_number]

      where file_number would be the binary log index of the next binary log to create (instead of being <log_bin_basename>.000001, the next binary log file would be <log_bin_basename>.<file_number>).

      This would allow to perform easy master promotion as discussed at slide # 31 of the below URL without "FLUSH BINARY LOGS" in a loop:
      -http://www.slideshare.net/JeanFranoisGagn/binlog-servers-at-bookingcom

      So if I have "log-bin = binlog" in my.cnf, a "RESET MASTER AT 1234" would generate "binlog.001234" as the next binary log file.

      Many thanks,

      JFG

        Attachments

          Issue links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                jgagne Jean-Francois Gagne
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: