MySQL Replication and Server Time

Posted on 2011-04-20
Last Modified: 2012-06-21
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?
Question by:Chad_J_Lemmer
    1 Comment
    LVL 10

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
    Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now