如何同步多个 Fedora 系统的时钟
我有一个订阅系统，允许用户订阅他们感兴趣的事物或人，并在提交新帖子、文件或图像时收到通知。 为了确定某件事是否是新的，我通过 tstamp 跟踪他们的观点。 问题是，如果网络服务器和 MySQL 数据库不同步，用户可能会错过在查看项目的同时发布的内容。 或将某个项目展示两次。
我可以通过从数据库检索 tstamp 来消除这个问题，但是为了获取 tstamp 需要与数据库进行大量连接。 如果我可以定期将网络服务器的系统时钟同步到我们的数据库服务器（至少尽可能），我至少可以大大减少问题。 有人对执行此操作的最佳方法有任何建议吗？
我不愿意使用 NOW() 将观看时间输入数据库。 我使用 Gearman Process 记录视图，这意味着进入视图时总会有轻微的延迟。 然而，一般来说，这种延迟是最小的，并且它可能小于系统时钟之间的差异，假设我无法进行定期同步。
I have a subscription system that allows users to subscribe to things or people they are interested in, and receive notifications when new posts or files or images are submitted. To determine whether something is new, I track their views by tstamp. The problem is that if the webserver and the MySQL database are out of sync, a user could miss content that is posted at around the same time they view an item. or be shown an item twice.
I can eliminate this problem by retrieving tstamp from the database, but that is a lot of connections to the database just to get a tstamp. If I could regularly sync the system clocks of the webservers to our db server (as well as possible, at least), I could at least significantly minimize the problem. Does anyone have any advice regarding the best way to do this?
I am reluctant to enter the view time into the database using NOW(). I record the views with a Gearman Process, which would mean that there is always a slight delay in entering the view. However, generally, this delay is minimal, and it might be smaller than the difference between the system clocks, assuming I can't get regular syncing going.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
启用 NTP。
您可能想要在 /etc/ntp.conf 中设置时间服务器，或使用使用 *.fedora.pool.ntp.org 的默认配置。
Enable NTP.
You may want to setup time servers in /etc/ntp.conf, or use the default config that uses *.fedora.pool.ntp.org.
对我来说，我只是在我的 crontab 中添加了一个脚本。 如果您有多个服务器需要配置，则快速而简单。
For me I just added a script to my crontab. Quick and simple if you have multiple servers to configure.