pt-table-sync - exclude columns
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
This is more of a feature request - please let me know if there is a different place to list feature requests.
The documentation for pt-table-sync states "It is not currently possible to exclude columns from the sync process itself, only from the comparison."
I currently have a use case where on host #1, there is a table called test with columns a1, a2, a3. On host #2, there is a table called test with columns a1, a2, a3, a4, a5.
I would like to sync the rows of the table from host #1 to host #2 on a regular basis (one way sync). Columns a4 and a5 are both default null, so I'm fine with new rows having null for those columns.
Is it possible for pt-table-sync to be able to do this sync? A couple options I thought of, all of which could work for my use case:
- a new command-line argument to only sync columns that exist in both tables
- a new command-line argument that lists the columns to sync
- a new command-line argument that lists the columns to exclude during the sync
Thanks for your help.
Ryan
Set to confirmed as feature request.