add possibility to Backup mysql databases with --skip-lock-tables option.
add the possibility to Backup mysql databases with --skip-lock-tables option.
-
Plesk Tech Support commented
One of our customer wants to create temporary tables during backup, thus causing the backup to fail as the tables are not locked.
It would be nice to have a way to call the backup manager so that when mysqldump runs, the skip-lock-tables and --single transactions can be optionally passed.
-
RW commented
We are looking for Percona XtraDB support. We can backup tables with the work-around for the script. However when we attempt to install wordpress locking is attempted and prevents the install. We would like a way to add the --skip-lock-tables to a creation. Ultimately, we want to run percona xtradb in strict enforcing mode.
-
Charles commented
We already have the work around for the backup process, the create database script that Plesk uses to create db's need to have that ability as well.
-
Charles commented
We would like to leverage Percona's XtraDB cluster. However to have the cluster in full operation mode, skip lock tables option needs to be added to any interaction with the db, creation, backup and restore.
-
Grigoriy Ovechkin commented
There is a workaround:
# cat /usr/local/psa/PMM/agents/shared/Db/MysqlShellBackend.pm
...
$cmd .= " --socket='$self->{socket}'" if $self->{socket};
$cmd .= " -h '$self->{host}'" if $self->{host};
$cmd .= " -u '$self->{user}'";
$cmd .= " -P '$self->{port}'" if $self->{port};
if (index($cmd, AgentConfig::mysqldumpBin()) != -1) {
$cmd .= " --skip-lock-tables";
}
$cmd .= " $additionalOptions" if $additionalOptions;
... -
Grigoriy Ovechkin commented
Add possibility to Backup mysql databases with "--skip-lock-tables" option.