Advanced MySQL 8

Global transaction identifier-based replication

To serve advanced MySQL topologies, MySQL has included global transaction identifier-based replication. It adds a unique identifier to each transaction committed on the server of origin called the master. By introducing GTID-based replication, you can identify the origin of the transaction and the order in which the transaction needs to be executed if all servers are part of the same group.

A GTID is represented as a pair of coordinates, separated by a colon (:), as shown here:

GTID =source_id:transaction_id

Where the source_id is the server's UUID specified in the configuration. transaction_id is a sequence number determined by the order in which the transaction was committed on this server. ...