MySQL defines GTID (global transaction identifier) as "... a unique identifier created and associated with each transaction committed on the server of origin (master) ..."1.

See also[edit]


  1. ^  This identifier is unique not only to the server on which it originated, but is unique across all servers in a given replication setup. There is a 1-to-1 mapping between all transactions and all GTIDs.
  2. ^  Semantic MediaWiki: GitHub issue gh:smw:3606 (`smw_ft_search` causes "Error: 1785 Statement violates GTID consistency: Updates to non-transactional tables ...")