MariaDB Documentation improvements (MDEV-6881)

[MDEV-8245] Update the MariaDB documentation about the privileges needed to set gtid_domain_id Created: 2015-05-28  Updated: 2015-06-25  Resolved: 2015-06-25

Status: Closed
Project: MariaDB Server
Component/s: Documentation, Replication
Affects Version/s: 10.0.19, 10.1
Fix Version/s: N/A

Type: Technical task Priority: Major
Reporter: Stoykov (Inactive) Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: GTID


 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

 Comments   
Comment by Stoykov (Inactive) [ 2015-05-28 ]

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
============================================================

Generated at Thu Feb 08 07:25:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.