[MDEV-12031] BACKUP LOCKS Created: 2017-02-09  Updated: 2020-08-25  Resolved: 2018-08-13

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

Type: Task Priority: Major
Reporter: VAROQUI Stephane Assignee: Unassigned
Resolution: Duplicate Votes: 8
Labels: Backup

Issue Links:
Blocks
is blocked by MDEV-8436 Implement "Backup Locks" such as "LOC... Closed
is blocked by MDEV-11657 Cross-engine transaction metadata Open
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   
  1. Implement BACKUP Locks as per https://www.percona.com/doc/percona-server/5.6/management/backup_locks.html#backup-safe-binlog-information . This aparently might help backup performance, once implemented, like here https://www.percona.com/doc/percona-xtrabackup/2.4/advanced/lockless_bin-log.htm

 Comments   
Comment by Vladislav Vaintroub [ 2017-02-09 ]

innodb backup is generally non-locking. xtrabackup also supports --no-lock to avoid FTWRL.
Is there anything else to be done?

Comment by VAROQUI Stephane [ 2017-02-09 ]

Percona claim's it's unique to percona-server so they must have done something else in redolog to support gtid inside innodb redolog no

Comment by Vladislav Vaintroub [ 2017-02-09 ]

Maybe you can paste a link to percona documentation, for better understanding?

Comment by VAROQUI Stephane [ 2017-02-09 ]

https://www.percona.com/doc/percona-xtrabackup/2.4/advanced/lockless_bin-log.html

Comment by Vladislav Vaintroub [ 2017-02-09 ]

This needs a lot of changes inside the server, from my cursory reading, aparently all of that
https://www.percona.com/doc/percona-server/5.6/management/backup_locks.html#backup-safe-binlog-information

LOCK TABLES FOR BACKUP, LOCK BINLOG FOR BACKUP. All that is not avalable in MariaDB

Comment by Vladislav Vaintroub [ 2017-02-09 ]

stephane@skysql.comI changed the description and the component of the feature, based on your description. This needs a server support, not just a backup feature.

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