Mysql复制-Slave库设置复制延迟

最新推荐文章于 2024-05-09 07:03:54 发布

weixin_30784141

最新推荐文章于 2024-05-09 07:03:54 发布

阅读量56

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/abclife/p/5691563.html

本文介绍了如何在MySQL中配置延迟复制，通过使用`stop slave;`命令暂停从库，然后设置`change master to master_delay=10;`来实现10秒的延迟，最后启动从库并验证设置是否生效。

mysql> stop slave;
mysql> change master to master_delay=10;#单位是秒
mysql> start slave;
mysql> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Waiting for master to send event
			   ...
                    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
           Master_Retry_Count: 86400
                  Master_Bind: 
      Last_IO_Error_Timestamp: 
     Last_SQL_Error_Timestamp: 
               Master_SSL_Crl: 
           Master_SSL_Crlpath: 
           Retrieved_Gtid_Set: 
            Executed_Gtid_Set: 
                Auto_Position: 0
1 row in set (0.00 sec)

mysql>

转载于:https://www.cnblogs.com/abclife/p/5691563.html