1.已经有主从配置延时从库
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
1.停止主从 mysql> stop slave; 2.设置延时从库 mysql> change master to master_delay=180; 3.开启主从 mysql> start slave; 4.查看主从状态 mysql> show slave status\G Slave_IO_Running: Yes Slave_SQL_Running: Yes SQL_Delay: 180 #延时的时间，单位是秒 SQL_Remaining_Delay: NULL #执行语句的倒计时，如果主没有执行任何语句，则为NULL |
2.如果没有主从配置延时从库
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
1.配置从库server_id 2.同步主库的数据 3.执行change语句 change master to master_host='172.16.1.51', master_user='rep', master_password='123', master_log_file='mysql-bin.000008', master_log_pos=534, master_delay=360; 4.开启主从 mysql> start slave; |
3.关闭延时从库
|
1 2 3 4 5 6 7 8 9 |
1.停止主从 mysql> stop slave; 2.延时时间为0 mysql> change master to master_delay=0; 3.开启主从 mysql> start slave; |