MySQL 5.6 引入了延迟复制功能，允许slave服务器滞后master至少指定时间。该功能可以防止用户错误，模拟延迟场景以及检查历史数据库状态。通过`master_delay`参数设置延迟时间，`show slave status`可查看延迟信息。延迟复制适用于灾难恢复、系统行为测试和历史数据审查。
前面一篇文章《mysql replication 主从间如何延迟 --- 某大型互联网面试题》已经写到如何延迟主从配置，在5.6里已经实现了这个功能，那么我们看一下官方文档介绍吧 ：
http://dev.mysql.com/doc/refman/5.6/en/replication-delayed.html
MySQL 5.6 supports delayed replication such that a slave server deliberately lags behind the master by at least a specified amount of time. The default delay is 0 seconds. Use theMASTER_DELAY option forCHANGE MASTER TO to set the delay to N seconds:
CHANGE MASTER TO MASTER_DELAY = N;
An event received from the master is not executed until at least
最低0.47元/天 解锁文章
扫一扫
857
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
