The following diagram shows how the replication process works:
A little explanation makes it easier to understand the process:
A client requests a write transaction on the master host.
The binary logs (also called binlogs) are updated. The binary logs contain events that describe database changes.
The slave receives the information from the master.
It then appends it to its relay logs.
The slave SQL thread replays the statements contained in the relay logs.
There are 2 kinds of replication mechanisms:
We will see both the mechanisms and understand the advantages of GTID. In both the cases, when a network cut occurs, it is able to automatically reconnect and resume the replication (depending on the retention days).
Now, since...