Not the answer you need?
Register and ask your own question!

Tables locked while incrementel backup

hugchrichugchric EntrantInactive User Role Beginner
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

Comments

  • mirfanmirfan Database Administrator Inactive User Role Beginner
    ==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 ?
  • hugchrichugchric Entrant Inactive User Role Beginner
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.