This section focuses on global transaction identifiers based replication. It explains how GTIDs are defined, created, and represented in MySQL server. It describes the procedure for setting up and starting GTID-based replication.
With GTID-based replication, each transaction is assigned a unique transaction ID as it is committed to the originating database server, known as GTID. The unique identifier is global, which means it is unique across all the database servers participating in replication. With GTID, it is easier to track and process each transaction as it is committed on to a master database server. With this replication method, it is not necessary to rely on the log files for synchronization ...