Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/duplicateserverid-advisor-ref.html
Tracks instances whose UUID is duplicated or becomes associated with multiple, different host names, or connections, over a specific time period. For example, if the Change Rate is set to 5, and Every set to 10 minutes, and the UUID of the instance ...These changes are measured by rate, that is, by a defined number of changes over the defined time ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-functions.html
It converts a binary UUID to a string UUID and returns the result. The binary value should be a UUID as a VARBINARY(16) value. (For details about this format, see the UUID() function description.) If the UUID argument is NULL, the return value is ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: 1778; Symbol: ER_CANT_DO_IMPLICIT_COMMIT_IN_TRX_WHEN_GTID_NEXT_IS_SET; SQLSTATE: HY000 Message: Cannot execute statements with implicit commit inside a transaction when @@SESSION.GTID_NEXT == 'UUID:NUMBER'. Error number: 1781; Symbol: ... The MySQL server writes some error messages to its error log, and sends others to client ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-concepts.html
The types of transactions used by replication are listed here: A GTID transaction is identified by a global transaction identifier (GTID) which takes one of two forms: UUID:NUMBER or UUID:TAG:NUMBER. Before setting the replication mode of an online ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-source-to.html
The following options are available for CHANGE REPLICATION SOURCE TO statements: ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS = {OFF | LOCAL | uuid} Makes the replication channel assign a GTID to replicated transactions that do not have one, enabling ...] ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
group_replication_group_name specifies the name of the group which this server instance belongs to, which must be a valid UUID. This UUID forms part of the GTIDs that are used when transactions received by group members from clients, and view change ... This section lists the system variables that are specific to the Group Replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-assign-anon.html
LOCAL assigns a GTID including the replica's own UUID (the server_uuid setting). uuid assigns a GTID including the specified UUID, such as the server_uuid setting for the replication source server. Using a nonlocal UUID lets you differentiate ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/glossary.html
UUID A unique identifier used to distinguish each MySQL instance, host machine, and agent. Because there is so much flexibility in spreading components across multiple systems or running multiple instances and agents on the same system, the ...
https://dev.mysql.com/doc/refman/8.4/en/bit-functions.html
Binary String Bit-Operation Examples The following example illustrates use of bit operations to extract parts of a UUID value, in this case, the timestamp and IEEE 802 node number. Convert the text UUID to the corresponding 16-byte binary value so ... Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit functions and operators: | Bitwise ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-functions.html
The UUID is the identifier used by the server where the transaction originated, which is normally the value of server_uuid. CREATE FUNCTION GTID_SUBTRACT_UUID(gs LONGTEXT, uuid TEXT) RETURNS LONGTEXT RETURN GTID_SUBTRACT(gs, CONCAT(UUID, ':1-', (1 ... This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID set is a subset of ...