xtrabackup incremental is failing against Percona server 5.7

MySQL & MariaDB Percona XtraBackup
1

Hello,

I met an ERROR when doing incremental backup:

Error: failed to execute query FLUSH NO_WRITE_TO_BINLOG CHANGED_PAGE_BITMAPS: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

I did the incremental backup with a user only have RELOAD, LOCK TABLES, PROCESS and REPLICATION CLIENT privileges. I don’t want to give the backup user the SUPER privilege.

I did the full backup with the same user and it finished successfully. I didn’t know why I need SUPER privilege to do the incremental backup.

I appreciate if anyone can help me this out.

Thanks,

Mehman Jafarov

2

You will need the SUPER privilege, based on the documentation:
[url]https://www.percona.com/doc/percona-xtrabackup/2.4/using_xtrabackup/privileges.html[/url]

SUPER in order to start/stop the slave threads in a replication environment, use XtraDB Changed Page Tracking for Incremental Backups and for Improved FLUSH TABLES WITH READ LOCK handling,