mysql replication 时间必须同步

本文主要是介绍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

这篇关于mysql replication 时间必须同步的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！