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.
LockMySQLOnlineBackup
0 likes · 3 min read