设置延迟复制

SQL_Delay：正数表明slave有延迟了。
SQL_Remaining_Delay：整数表明延迟时间。
Slave_SQL_Running_State：表明sql线程状态。
master_delay 单位为秒。


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)