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.

Goal

Eliminate erroneous reporting of replication lag on the replica due to unsynced system clocks.

Solution

	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

Goal

Solution

References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

Avoid Problems with Replication Lag Reporting by Syncing System Clocks (Doc ID 2152473.1)

Applies to:

Goal

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!