Avoid Problems with Replication Lag Reporting by Syncing System Clocks
(Doc ID 2152473.1)
Last updated on JANUARY 05, 2022
Applies to:MySQL Server - Version 4.0 and later
Information in this document applies to any platform.
System clocks on replica and source being out of sync can result in erroneous reporting of "seconds behind source" on replica servers, with the lag increasing further as the clocks drift further apart.
This problem can be avoided by keeping server clocks synced with a network time source. On Linux systems, this could be accomplished by properly configuring and running the NTP service.
Eliminate erroneous reporting of replication lag on the replica due to unsynced system clocks.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document