Details
-
Type:
Technical task
-
Status: Closed (View Workflow)
-
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