[MDEV-8436] Implement "Backup Locks" such as "LOCK TABLES FOR BACKUP" and "LOCK BINLOG FOR BACKUP" Created: 2015-07-09  Updated: 2019-06-13  Resolved: 2015-07-17

Status: Closed
Project: MariaDB Server
Component/s: Admin statements
Fix Version/s: N/A

Type: Task Priority: Minor
Reporter: Chris Calender (Inactive) Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-12031 BACKUP LOCKS Closed
Duplicate
is duplicated by MDEV-5336 Implement BACKUP STAGE for safe exter... Closed
Relates
relates to MDEV-18917 Don't create xtrabackup_binlog_pos_in... Closed

 Description   

I'd like to request that we add (or backport) the "Backup Locks", such as "LOCK TABLES FOR BACKUP", "LOCK BINLOG FOR BACKUP", and "UNLOCK BINLOG" as described here:

https://www.percona.com/doc/percona-server/5.6/management/backup_locks.html#backup-locks

"LOCK TABLES FOR BACKUP uses a new MDL lock type to block updates to non-transactional tables and DDL statements for all tables. More specifically, if there’s an active LOCK TABLES FOR BACKUP lock, all DDL statements and all updates to MyISAM, CSV, MEMORY and ARCHIVE tables will be blocked in the Waiting for backup lock status as visible in PERFORMANCE_SCHEMA or PROCESSLIST.
...
Unlike FLUSH TABLES WITH READ LOCK, LOCK TABLES FOR BACKUP does not flush tables, i.e. storage engines are not forced to close tables and tables are not expelled from the table cache. As a result, LOCK TABLES FOR BACKUP only waits for conflicting statements to complete (i.e. DDL and updates to non-transactional tables). It never waits for SELECTs, or UPDATEs to InnoDB tables to complete, for example.
..."

Thank you for your consideration.


Generated at Thu Feb 08 07:27:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.