GTID Format and Storage

Question 1

GTID

Answer 1

• A global transaction identifier (GTID) is a unique identifier
• created and associated with each transaction committed
• on the server of origin (the source)
• unique across all servers in a given replication topology

Question 2

GTID
What is the difference between client transactions replicated transactions

Answer 2

client transactions:
* which are committed on the source
* it is assigned a new GTID

Replicated transactions:
* retain the same GTID that was assigned to the transaction on the server of origin

Question 3

auto-skip function for GTIDs

Answer 3

means that a transaction committed on the source can be applied no more than once on the replica

Question 4

GTID representation

Answer 4

GTID = source_id:transaction_id

• source_id identifies the originating server
• the transaction_id is a sequence number determined by the order in which the transaction was committed on the source.

Question 5

upper limit for sequence numbers for GTIDs

Answer 5

signed 64-bit integer
+-9,223,372,036,854,775,807

Question 6

GTID Sets

Answer 6

3E11FA47-71CA-11E1-9E33-C80AA9429562:1-3:11:47-49

A GTID set can include any combination of
* single GTIDs and
* ranges of GTIDs,
* and it can include GTIDs originating from different servers