pt-table-sync: Please add to documentation, that "REPLACE INTO" will fire "insert trigger" in mysql variants
Bug #1622663 reported by
Lars Erler
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona Toolkit moved to https://jira.percona.com/projects/PT |
Confirmed
|
Undecided
|
Unassigned | ||
Bug Description
Please add the following to the documentation of pt-table-sync https:/
* pt-table-sync uses "REPLACE INTO", which will fire "insert trigger" in all mysql variants
This can be a huge drawback / data loss (overwrite) risk, if user sets via insert trigger reasonable default values for certain columns / other tables.
Example: "REPLACE INTO products" will fire trigger to set default price in "products_price" and finally overwritten by default value again :(
What irritates me most is, that there is even a cmd-line option " --[no]check-
which checks that no triggers are defined on the destination table. Maybe highlight this much more in the doc part.
Revision history for this message
| Sveta Smirnova (svetasmirnova) wrote | #1 |
| tags: | added: pt-table-sync |
| Changed in percona-toolkit: | |
| status: | New → Confirmed |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #2 |
To post a comment you must log in.
Thank you for the reasonable documentation request.