• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 373
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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