Search Results
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-status.html
Assign_gtids_to_anonymous_transactions_value [None] 15 The UUID used in the GTIDs assigned to anonymous transactions . A replica server creates two replication metadata repositories, the connection metadata repository and the applier metadata ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-encryption-keys.html
The format of binary log encryption keys in the keyring is as follows: MySQLReplicationKey_{UUID}_{SEQ_NO} For example: MySQLReplicationKey_00508583-b5ce-11e8-a6a5-0010e0734796_1 {UUID} is the true UUID generated by the MySQL server (the value of ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-agent-rights.html
During discovery, the agent creates the table inventory within the mysql database that stores the UUID for the server. Without this table, the agent cannot determine the UUID of the server, which it sends along with other information to MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-functions.html
mask_uuid(str [, mask_char]) Masks a Universally Unique Identifier (UUID) and returns the number with all meaningful characters replaced by '*' characters. Return value: The masked UUID as a string encoded in the utf8mb4 character set, an error if ...mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-configuration-table.html
LOCAL means a GTID is assigned that includes the replica's own UUID (the server_uuid setting). UUID means a GTID is assigned that includes a manually set UUID. ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE The UUID that is used as part of the GTIDs ... This table shows the configuration parameters that affect transactions applied by the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-lifecycle.html
This client transaction is assigned a GTID composed of the source's UUID and the smallest nonzero transaction sequence number not yet used on this server. If you set gtid_next to a valid GTID (consisting of a UUID, an optional tag, and a transaction ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-additionalslaves.html
To do this, you can set up the new replica by copying the data directory of an existing replica, and giving the new replica a different server ID (which is user-specified) and server UUID (which is generated at startup). After copying, delete the ...
https://dev.mysql.com/doc/workbench/en/dbdoc-templates-custom.html
MySQL's UUID() function also generates GUIDs: mysql> SELECT UUID(); +--------------------------------------+ | UUID() | +--------------------------------------+ | 648f4240-7d7a-11e0-870b-89c43de3bd0a | +--------------------------------------+ Once ... In the simplest case, a template consists of two files: a template file, which has a .tpl extension, and a special file ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-replicationreplica-category.html
Source Server Inv Uuid The uuid from the source mysql.inventory table, generated by MySQL Enterprise Monitor. Lists the Replication Replica configuration metrics and provides a brief description of each. Table 7.29 Replication Replica Configuration ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-deployment-config-agent-options.html
default uses either the server_uuid variable, if present, or generates a new uuid. The following table lists the default locations for each supported operating system: Important These parameters enable you to configure MySQL Enterprise Monitor Agent ...