说明：本文使用rockylinxu8.10为操作系统编写的教程，centos系的操作系统通用。
1.下载percona-toolkit最新的安装包，下载地址：https://www.percona.com/downloads
wget https://downloads.percona.com/downloads/percona-toolkit/3.7.0/binary/redhat/9/x86_64/percona-toolkit-3.7.0-1.el9.x86_64.rpm
2.使用命令安装percona-toolkit，具体命令如下：
sudo dnf localinstall percona-toolkit-3.7.0-1.el9.x86_64.rpm -y
3.编写同步命令，以在/home/tongbu目录创建tongbu.sh为例，具体命令如下：
mkdir /home/tongbu
vi /home/tongbu/tongbu.sh
按i
#!/bin/bash
cmd=${1}
syn_tables=('XYSTZZ_BCRZXX' 'XYSTZZ_CBXX' 'XYSTZZ_CKXQXX' 'XYSTZZ_CPKXX' 'XYSTZZ_CPZLXX' 'XYSTZZ_JSXX' 'XYSTZZ_JTPSDWXX' 'XYSTZZ_JYXZBMXX' 'xystzz_mb' 'XYSTZZ_MRSPXX' 'XYSTZZ_NJXX' 'XYSTZZ_RKXQXX' 'XYSTZZ_SCCGDDMXXX' 'XYSTZZ_SCCGDDXX' 'XYSTZZ_SCCGDDYSMXXX' 'XYSTZZ_SCCGDDYSXX' 'XYSTZZ_SCPSDWHZSTXX' 'XYSTZZ_SCPSDWJSXQXX' 'XYSTZZ_SCPSDWXX' 'XYSTZZ_SCXX' 'XYSTZZ_SPCKXX' 'XYSTZZ_SPKCXX' 'XYSTZZ_SPRKXX' 'XYSTZZ_STSRXX' 'XYSTZZ_STXX' 'XYSTZZ_STYGXX' 'XYSTZZ_STZCXX' 'XYSTZZ_TCXX' 'XYSTZZ_XQXX' 'XYSTZZ_XSXX' 'XYSTZZ_XXJCXX' 'XYSTZZ_XXXX' 'XYSTZZ_YCDDXX' 'XYSTZZ_YCPJXX' 'XYSTZZ_YGWBPQFWFJSXQ')
source_TDSN='h=源数据库地址,D=源数据库名称,u=账号,p=密码,t='
target_DSN='h=目标数据库地址,D=目标数据库名称,u=账号,p=密码'
echo === start syn tables ===
for t in ${syn_tables[*]}; do
sDSN=${source_TDSN}${t}
echo "====syn: ${sDSN} to prod"
pt-table-sync --execute --no-check-slave ${sDSN} ${target_DSN} $cmd
done
echo === fnish syn tables ===
:wq
vi /home/tongbu/run.log
:wq
4.设置定时任务，可以使用cron，如果有安装宝塔、1panel之类面板的可以用定时任务，具体同步频率按自己需要设置，命令如下：
/bin/sh /home/tongbu/tongbu.sh > /home/tongbu/run.log 2>&1 &
