In Replication Chain Slaves Two or More Links Away From the Master Get Out of Sync or Replication Fails; Error: Column cannot be null; log-slave-updates
Last updated on MARCH 08, 2017
Applies to:MySQL Server - Version 4.0 to 5.6 [Release 4.0 to 5.6]
Information in this document applies to any platform.
With the following conditions fullfilled:
- The replication setup involves a master that replicates to a slave that is itself master for one or more slaves. See also the diagram below.
- User variables are used for the statements being replicated.
- The statements are replicated using the STATEMENT based format.
- Table level replication filters are used on Slave A.
In this case it can happen that Slave B either get out of sync with Master or Slave A, or a replication error such as
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms