This tutorial demands a service restart since some flags here presented can not be dynamically changed
What is GTID and why do I need it? Directly from the MySQL documentation (excerpt taken as
is with different jargons than used here, for
master/slave we are using
primary/replica):
A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the master). This identifier is unique not only to the server on which it originated, but is unique across all servers in a given replication topology.
GTID assignment distinguishes between client transactions, which are committed on the master, and replicated transactions, which are reproduced on a slave. When a client transaction is committed …
[Read more]