My Oracle Support Banner

How to skip the LOST_EVENTS error on the MySQL Replica (Doc ID 1325383.1)

Last updated on DECEMBER 06, 2021

Applies to:

MySQL Cluster - Version 6.3 and later
Information in this document applies to any platform.

Goal

Disclaimer: Starting from v8.0, some terms have been deprecated. Older releases will only use the deprecated terminology, and new releases will only use new terminology. Please see https://dev.mysql.com/doc/mysqld-version-reference/en/ for a complete list of those changes, and in which minor versions it happened.

You are geographically replicating your MySQL Cluster to another Cluster and your replica MySQL server received the LOST_EVENTS event. This happens because on the source side, the MySQL doing binary logging stopped and it will probably miss updates while not running. The replica MySQL server stops so some action may be taken e.g. checking consistency of data and/or switching replication channel. However, there are situations where you just want the replica MySQL server to continue replication, ignoring the LOST_EVENTS event.

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!

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