Skip to main content

NetApp_Insight_2020.png 

NetApp Knowledgebase

MySQL replication problem in an NLB SnapCenter configuration

Views:
88
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:

Applies to

  • SnapCenter Server 4.0 and above
  • NLB configuration 


Issue

Customers get errors and (if configured) an email every minute reporting an issue with the MySQL replication. 

Following error appears:
Replication of the repository failed on the database server 

The reason and result of the failure is seen as following:

Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from position > file size'

The replica is requesting data at a certain point in the log (its current position), but the master's log file does not reach that point (so there are missing entries). Replication stops because this is a logic error.

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support