Using --preserve-triggers on pt-online-schema-change results in this error message:
Percona-XtraDB-Cluster prohibits use of LOCK TABLE/FLUSH TABLE WITH READ LOCK with pxc_strict_mode = ENFORCING
When looking at the script, this seems to be hardcoded:
/usr/bin/pt-online-schema-change:11074: push @$sqls, “LOCK TABLES
Commenting out this line seems to work fine. Before we had to drop / create the triggers in our own management scripts and we didn’t lock there either. Anyway, two questions:
- is it safe to use this feature without table write locking?
- are there plans to fix the pt-osc script? I don’t like using hacked scripts; they’ll break on the next update
Ps. 3rd question: is it me, or is it true this forum doesn’t have a search option?