Aikesheng Open Source Community

Aug 28, 2020 · Databases

MySQL 8.x Lightweight Backup Lock: LOCK INSTANCE FOR BACKUP Explained

MySQL 8.x adds a lightweight backup lock, LOCK INSTANCE FOR BACKUP, which permits DML during online backups while restricting only file creation, account changes, and certain table operations, requiring BACKUP_ADMIN privilege and offering a less disruptive alternative to FTWRL, used by MySQL Enterprise Backup and Percona Xtrabackup.