Aikesheng Open Source Community

Jul 25, 2022 · Databases

Resolving MySQL Manual Backup Errors Caused by Incorrect gtid_mode Setting

During routine MySQL maintenance a manual backup failed because the server could not parse the last GTID from the backup log, which was traced to an incorrect gtid_mode value (OFF_PERMISSIVE) and resolved by setting gtid_mode to ON and restarting the instance.