myslq使用 MASTER_DELAY 可以设置mysql主从复制延迟
语法:CHANGE MASTER TO MASTER_DELAY = 30;
#备注:设置备节点延迟的时间,单位秒。
具体使用:
root@localhost:mysql>stop slave;
Query OK, 0 rows affected (0.21 sec)
root@localhost:mysql>CHANGE MASTER TO MASTER_DELAY = 30;
Query OK, 0 rows affected (0.17 sec)
root@localhost:mysql>start slave;
Query OK, 0 rows affected (0.27 sec)
查看节点状态:
select * from slave_relay_log_info\G
show slave status\G