My Oracle Support Banner

How to Recover from Replication Relay Log Corruption (Doc ID 1638949.1)

Last updated on MAY 07, 2021

Applies to:

MySQL Server - Version 5.1 and later
Information in this document applies to any platform.
Replication Relay Log is a copy of events from Source Binary log downloaded onto Replica by Replica IO thread for processing by Replica SQL thread(s).

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.

Recover Replication after Replica Relay log corruption.

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
 Pre-implementation steps
 Implementation steps - automatic recovery with MySQL Server restart
 Implementation steps - manual recovery
 Not using GTIDs
 Using GTIDs
References


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