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

            Assignee:
            greenman Ian Gilfillan
            Reporter:
            ivan.stoykov@skysql.com Stoykov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration