I installed a Percona XtraDB cluster with
pxc_strict_mode set to
ENFORCING, and am trying to import databases from non-Galera MariaDB servers. This works fine for some databases, by dumping them via
mysqldump --skip-locks -K and importing them via
mysql <database> < <dumpfile> (after creating a blank database using
One database however is refused the import:
ERROR 1105 (HY000) at line 40: Percona-XtraDB-Cluster prohibits use of ALTER command on a table (example.example) that resides in non-transactional storage engine (except switching to transactional engine) with pxc_strict_mode = ENFORCING or MASTER
Most internet threads simply suggest temporarily disabling
pxc_strict_mode. Given however that other databases import without any issues, I assume the issue should be resolvable by altering either the the flags appended to
mysqldump, or modifying the statements inside the dumpfile. I attempted removing all ALTER statements in the dump, which changes the above error to
...prohibits the use of DML command....
Both, the source MariaDB instance, as well as the new XtraDB Cluster, are configured with the default InnoDB storage engine.
Would appreciate any input.