MySQL复制-设置延迟复制
2016-07-06 17:00 abce 阅读(356) 评论(0) 编辑 收藏 举报mysql> stop slave ; Query OK, 0 rows affected (0.00 sec) mysql> change master to master_delay=10; Query OK, 0 rows affected (0.02 sec) mysql> start slave; Query OK, 0 rows affected (0.01 sec) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Connecting to master ... Master_Info_File: /var/mysql/data/master.info SQL_Delay: 10 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it ... Auto_Position: 0 1 row in set (0.00 sec) mysql>