4 ms·
Does this sync / delete tables in the correct order so that there are no foreign key constraint issues? Also, does it diff rows to tell what rows have actually
by caleblloyd 10y ago
Does this sync / delete tables in the correct order so that there are no foreign key constraint issues? Also, does it diff rows to tell what rows have actually changed or does it attempt to update every row every time? Does it handle cases where primary keys are not configured?
Percona's pt-table-sync has quite an extensive man page and explains how it accomplishes these. It may be a good reference to update your README.md to explain how the syncing works in gopli: https://www.percona.com/doc/percona-toolkit/2.2/pt-table-sync.html https://www.percona.com/doc/percona-toolkit/2.2/pt-table-syn...
- timakin 10y agoThis reference looks nice. Thank you for your comment. Gopli's README is so plain and just a kind of overview. So I should write down the process of syncing and notice about key-constraint and so on.