Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8436

Implement "Backup Locks" such as "LOCK TABLES FOR BACKUP" and "LOCK BINLOG FOR BACKUP"

    XMLWordPrintable

    Details

      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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              ccalender Chris Calender
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration