My Oracle Support Banner

Factors Affect Slave Replication Delay (Doc ID 2206223.1)

Last updated on APRIL 02, 2017

Applies to:

MySQL Server - Version 5.6 and later
Information in this document applies to any platform.

Symptoms

In a replication environment , one or more of the configured SLAVEs can temporarily or permanently fail to keep up with and being lagging behind the master node.

Changes

 If there have been no scheduled changes made in the environment then it could be related by design or simple data growth over time. Investigation and isolation is required to assess the reasons.

Cause

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
Symptoms
Changes
Cause
 Hardware
 Operating System config
 MySQL Server Version
 MySQL Server config
 Schema / Database Level differences
Solution


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