Sep 24, 2018

MySQL 5.7 supports delayed replication such that a slave server deliberately lags behind the master by at least a specified amount of time.

The default delay is 0 seconds. Use the MASTER_DELAY option for CHANGE MASTER TO to set the delay to N seconds:

CHANGE MASTER TO MASTER_DELAY = N;