January 2019
Intermediate to advanced
286 pages
7h 41m
English
From MySQL 5.6, MySQL developers have come up with a new replication mechanism called delayed replication, where a slave deliberately doesn't execute the events received from MySQL master for a set number of seconds. The MySQL variable for this is as follows: > CHANGE MASTER TO MASTER_DELAY = N;.
Where N specifies the number of seconds.
Use cases
From MySQL 8.0.1, for every global transaction identifier (GTID)-based transaction, a replication lag can be determined by the difference between the timestamp ...
Read now
Unlock full access