When I fully backup an instance using the XtraBackup utility, the tables are locked and the DB cannot be accessed.
How can I fix it?
@DarioV Hi, looking at the notes for this feature, it appears lock is expected.
During a MySQL backup operation of database that contains only innodb storage engine tables, when the MySQL dump command is executed with parameters master-data and single-transaction, an implicit lock is acquired on the database.
You can avoid the locking of database by using Percona XtraBackup utility to run MySQL backup operations. Using this utility, you can run non-blocking backup operation on the database that has tables of only innodb storage engine.
So appears to be expected behaviour.Regards,
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.