Tables locked while incrementel backup

MySQL & MariaDB Percona XtraBackup
1

Hello Community

I want to do an incremental backup between 8 - 18 o’clock every 2 hours.

But the problem is while the backup is running the data will be locked and the user can’t work.
In the database i have just innodb tables.

I run the script with the followed parameters:
innobackupex --user=“$MYSQL_USER” --password=“$MYSQL_PASS” --no-lock --incremental --incremental-basedir=“$LAST_BACKUP” "$INCREMENTALS_DIRECTORY

I have no replication server.

Is it possible to do a hotbackup whitouht a replication server?
Do execute the backup-script with the correct parameter or some ohter mistakes?

Thanks for your help.
Christoph

2

==no=lock option will disable table lock with FTWRL for InnoDB tables only. As you said, you only have InnoDB tables so lock shouldn’t taken place. Are you running any DDL during backup run ? How do you identified that data is locked ? Can you please share “SHOW FULL PROCESSLIST\G” & “SHOW ENGINE INNODB STATUS\G” output when tables are locked during backup run ?

3

Hey Mirfan

While the backup is running there are’t running any DDL statments. Just select, insert and update.

My impression is, that at the second incremental backup the tables are locked because the UI from the application don’t get any response.