Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6881 MariaDB Documentation improvements
  3. MDEV-8245

Update the MariaDB documentation about the privileges needed to set gtid_domain_id

    XMLWordPrintable

Details

    Description

      At https://mariadb.com/kb/en/mariadb/global-transaction-id/#gtid_domain_id needs to be added that in a view to set session gtid_domain_id the user has to be a SUPER user.

      Description: This variable is used to decide which replication domain new GTIDs are logged in for a master server. 
      See Use with multi-source replication and other multi-master setups for details. This variable can also be set on the session level.
      This is used by mysqlbinlog to preserve the domain ID of GTID events.

      if not, an error will be received:

      MariaDB [(none)]> set session gtid_domain_id=3;
      ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation

      related MDEV: https://mariadb.atlassian.net/browse/MDEV-6901

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            ivan.stoykov@skysql.com Stoykov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.