Details
-
Type:
Technical task
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.0.19, 10.1
-
Fix Version/s: N/A
-
Component/s: Documentation, Replication
-
Labels:
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
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Example:
============================================================
gtid_domain_id
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 only by a SUPER user. This is used by mysqlbinlog to preserve the domain ID of GTID events.
Scope: Global, Session
Dynamic: Yes
Data Type: numeric (32-bit unsigned integer)
Introduced: MariaDB 10.0.2
============================================================