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

dynamically enable/disable binlog

    XMLWordPrintable

Details

    Description

      This task would be to re enabling dynamic global binlog setting in MariaDB ?

      set global log_bin=OFF;
      Variable 'log_bin' is a read only variable;

      Most common scenario are

      • production server that simply can't be restarted and need to become master
      • Spider, Galera can control binlog to resync node (removing gcache)
      • Dynamic auto configuration scripts
      • Fail over scripts can promote a slave that as no binlog

      SQL_LOG_BIN can be use for SESSIONS and LOG_BIN=0N for GLOBAL
      We get the best of all world and no risk of confusion.

      Other solution would be to introduce new GRANTS
      GLOBAL BINARY LOG

      Thanks

      Attachments

        Activity

          People

            Unassigned Unassigned
            stephane@skysql.com VAROQUI Stephane
            Votes:
            3 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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