Details
-
Technical task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.19, 10.1(EOL)
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