pt-table-sync - exclude columns

[Ryan Brothers]

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

[Nilnandan Joshi (nilnandan-joshi)]

Set to confirmed as feature request.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1185