Global transaction identifiers based replication

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 ...

Get MySQL 8 Administrator's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.