MySQL复制-设置延迟复制

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

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>