Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 368
  • Last Modified:

MySQL Replication and Server Time

We have 2 MySQL servers doing master/slave replication.

The server time on the master is about 20 minutes slow, and the time on the slave is right on.

Is setting the time on the master server to the correct time going to do anything to replication?  Is there anything date/time sensitive when it comes to how MySQL does replication that is going to stop functioning when I correct the master server's time?
0
Chad_J_Lemmer
Asked:
Chad_J_Lemmer
1 Solution
 
APNFSSCCommented:
I think you will find that the timestamp's in both database's show the time value from the master servers date time.

Probably the only thing you will notice is that the slave is always lagging I would think when you do a show slave status on the slave server it's probably showing 20 minutes behind the master...

If you update the time on the master server you should setup ntpd on both servers and get them exactly the same, and shut down mysqld on both for it to take affect.
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now