Shulou(Shulou.com)06/01 Report--

MySQL 5.7 delayed replication is achieved by setting the replication parameter MASTER_DELAY (in seconds, that is, the SQL is executed after the delay from the library)

For example:

Mysql > show slave status\ gateway * 1. Row * * Slave_IO_State: Waiting for master to send event Master_Host: 10.10.1.101. Slave_IO_Running: Yes Slave_SQL_Running: Yes. Seconds_Behind_Master: 0. SQL_Delay: 0 SQL_Remaining_Delay: 0. Channel_Name: master Master_TLS_Version: 1 row in set (0.00 sec)

Configure replication master latency of 14400 seconds

Mysql > stop slave;Query OK, 0 rows affected (0.00 sec) mysql > CHANGE MASTER TO MASTER_DELAY=14400 for channel 'master'; Query OK, 0 rows affected (0.01 sec) `1qmysql > start slave;Query OK, 0 rows affected (0.01 sec)

View the result

Mysql > show slave status\ gateway * 1. Row * * Slave_IO_State: Opening tables Master_Host: 10.10.1.101. Slave_IO_Running: Yes Slave_SQL_Running: Yes. Seconds_Behind_Master: 12. SQL_Delay: 14400 SQL_Remaining_Delay: 12. Channel_Name: master Master_TLS_Version: 1 row in set (0.00 sec)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.