sync a mysql table between 2 remote db + crontab

-sync a MySQL table between two remote databases.
dung cai nay: https://central.superhost.vn/knowledgebase/207/Hng-dn-thc-hin-Dump-1-table-trong-mysql.html
http://serverfault.com/questions/356070/how-to-sync-two-mysql-tables-on-demand-or-via-cron
http://www.maatkit.org/doc/mk-table-sync.html
http://codeinthehole.com/writing/how-to-sync-a-mysql-table-between-two-remote-databases/
http://www.unix.com/web-programming/125834-how-do-you-sync-tables-mysql-between-two-different-servers.html
http://stackoverflow.com/questions/15577073/how-to-sync-two-mysql-tables
http://stackoverflow.com/questions/7707859/mysql-database-sync-between-two-databases

cau lenh sync 1 hoac nhieu table: mysqldump -u username -p db_name table1_name table2_name table3_name > dump.sql
sau do restore bao db mong muon
http://stackoverflow.com/questions/2987366/how-to-dump-only-specific-data-table-from-a-database-in-mysql
http://dba.stackexchange.com/questions/9306/how-do-you-mysqldump-specific-tables

-mysqldumper
http://sinhvienit.net/forum/huong-dan-dung-mysqldumper-de-backup-tu-dong-va-gui-data-sang-host-khac.197881.html
crontab
http://www.hvaonline.net/hvaonline/posts/list/20066.hva

-pt-table toolkit
http://ulaptech.blogspot.com/2013/11/yum-install-percona-toolkit-maatkit.html
http://www.percona.com/doc/percona-toolkit/2.2/pt-table-sync.html
cach debug
http://stackoverflow.com/questions/19262619/synchronization-bidirectional-with-pt-table-sync
ghi chú: thêm --execute sau pt-table-sync để thực hiện đồng bộ.