mysql replication 时间必须同步

如果时间不同步,再同步的过程中对应修改数据不会同步过去.

errorlog中会有类似如下提示:

Invalid replication timestamps: original commit timestamp is more recent than the immediate commit timestamp. This may be an issue if delayed replication is active. Make sure that servers have their clocks set to the correct time. No further message will be emitted until after timestamps become valid again.


设定与阿里云服务器同步

ntpdate -u time1.aliyun.com


上一篇:javascript中的节点js / MongoDB副本集数组


下一篇:MySQL表级复制