All posts by Sujatha Sivakumar

About Sujatha Sivakumar

MySQL Server sustaining team engineer. Employed with ORACLE for the past two years. Main job role is to fix bugs in replication module.

Relay Log Recovery when SQL Thread’s Position is Unavailable

This blog explains how relay log recovery happens in a scenario where an applier thread (SQL_Thread) is starting for the first time and its starting position is not available for relay log recovery operations. If you are using GTIDs with MASTER_AUTO_POSITION then the following is more or less irrelevant since we then employ a more resilient repositioning scheme.…