命令行集中部署8到8同步(1台机器)
1.修改数据库参数
wal_keep_segments=4
wal_level='logical'
重启数据库
2.解压replicator包和ruby包,并配置环境变量
tar -zxvf KingbaseFlySync-V002R002B20220718-replicator.tar.gz
unzip rbenv_2.2.2_linux_x64.zip
vim .bash_profile
export RUBY_HOME=/home/kingbase/rbenv/ruby
PATH=$RUBY_HOME/bin:$PATH
export PATH
3.配置flysync.ini同步配置
[defaults]
install-directory = /home/kingbase/flysync
profile-script = ~/.bash_profile
rmi-port = 11000
[kstart]
kufl-port = 3112
datasource-type = kingbase
role = master
replication-host = 127.0.0.1
replication-port = 54321
replication-user = system
replication-password = 123456
repl_auto_recovery_max_attempts = 0
repl_auto_recovery_delay_interval = 5s
repl_auto_recovery_reset_interval = 300s
repl_mode = normal
property=replicator.extractor.dbms.enableLob=false
property=replicator.extractor.dbms.minRowsPerBlock=1000
master = 127.0.0.1
members = 127.0.0.1
kingbase-dbname = kstart
kingbase-extractor-method = xlogical
datasource-version = 8
[kend]
kufl-port = 3113
datasource-type = kingbase
role = slave
replication-host = 127.0.0.1
replication-port = 54321
replication-user = system
replication-password = 123456
repl_auto_recovery_max_attempts = 0
repl_auto_recovery_delay_interval = 5s
repl_auto_recovery_reset_interval = 300s
repl_mode = normal
property = replicator.applier.dbms.optimizeRowEvents=true
property = replicator.applier.dbms.maxRowBatchSize=20
property = replicator.applier.failure_policy=warn
svc-remote-filters=rename
master = 127.0.0.1
members = 127.0.0.1
master-kufl-port = 3112
datasource-version = 8
svc-parallelization-type = none
kingbase-dbname = kend
4.拷贝驱动包
cp KingbaseFlySync-V002R002B20220718-replicator/extensions/jdbc/kingbase8-8.6.0.jar KingbaseFlySync-V002R002B20220718-replicator/flysync-replicator/lib/
5.部署同步
KingbaseFlySync-V002R002B20220718-replicator/tools/fspm install
部署完成后生成/home/kingbase/flysync同步服务目录
6.拷贝授权
cp licensekfs.dat flysync/license.dat
7.配置目标端rename.csv对象转换配置
vim flysync/filters-config/rename.csv
flysync_kstart,*,*,flysync_kend,-,-
指将源端flysync_kstart模式同步到目的端flysync_kend模式
8.启动同步服务但不启动同步节点
/home/kingbase/flysync/flysync/flysync-replicator/bin/replicator start offline
9.重置同步位置
/home/kingbase/flysync/flysync/flysync-replicator/bin/fsrepctl -service kstart reset -all -y
/home/kingbase/flysync/flysync/flysync-replicator/bin/fsrepctl -service kend reset -all -y
10.启动同步节点
/home/kingbase/flysync/flysync/flysync-replicator/bin/fsrepctl -service kstart online
/home/kingbase/flysync/flysync/flysync-replicator/bin/fsrepctl -service kend online
11.同步测试
命令行集中部署8到8同步(2台机器)
1.修改数据库参数
wal_keep_segments=4
wal_level='logical'
重启数据库
2.解压replicator包和ruby包,并配置环境变量
tar -zxvf KingbaseFlySync-V002R002B20220718-replicator.tar.gz
unzip rbenv_2.2.2_linux_x64.zip
vim .bash_profile
export RUBY_HOME=/home/kingbase/rbenv/ruby
PATH=$RUBY_HOME/bin:$PATH
export PATH
3.源端配置flysync.ini同步配置
[defaults]
install-directory = /home/kingbase/flysync
profile-script = ~/.bash_profile
rmi-port = 11000
[kstart]
kufl-port = 3112
datasource-type = kingbase
role = master
replication-host = 192.168.23.129
replication-port = 54321
replication-user = system
replication-password = 123456
repl_auto_recovery_max_attempts = 0
repl_auto_recovery_delay_interval = 5s
repl_auto_recovery_reset_interval = 300s
repl_mode = normal
property=replicator.extractor.dbms.enableLob=false
property=replicator.extractor.dbms.minRowsPerBlock=1000
master = 192.168.23.129
members = 192.168.23.129
kingbase-dbname = kstart
kingbase-extractor-method = xlogical
datasource-version = 8
4.目的端配置flysync.ini同步配置
[defaults]
install-directory = /home/kingbase/flysync
profile-script = ~/.bash_profile
rmi-port = 11000
[kend]
kufl-port = 3113
datasource-type = kingbase
role = slave
replication-host = 192.168.23.130
replication-port = 54321
replication-user = system
replication-password = 123456
repl_auto_recovery_max_attempts = 0
repl_auto_recovery_delay_interval = 5s
repl_auto_recovery_reset_interval = 300s
repl_mode = normal
property = replicator.applier.dbms.optimizeRowEvents=true
property = replicator.applier.dbms.maxRowBatchSize=20
property = replicator.applier.failure_policy=warn
svc-remote-filters=rename
master = 192.168.23.129
members = 192.168.23.130
master-kufl-port = 3112
datasource-version = 8
svc-parallelization-type = none
kingbase-dbname = kend
4.两端拷贝驱动包
cp KingbaseFlySync-V002R002B20220718-replicator/extensions/jdbc/kingbase8-8.6.0.jar KingbaseFlySync-V002R002B20220718-replicator/flysync-replicator/lib/
5.两端部署同步
KingbaseFlySync-V002R002B20220718-replicator/tools/fspm install
部署完成后各自生成/home/kingbase/flysync同步服务目录
6.两端拷贝授权
cp licensekfs.dat flysync/license.dat
7.配置目标端rename.csv对象转换配置
vim flysync/filters-config/rename.csv
flysync_kstart,*,*,flysync_kend,-,-
指将源端flysync_kstart模式同步到目的端flysync_kend模式
8.两端启动同步服务但不启动同步节点
129发送端执行/home/kingbase/flysync/flysync/flysync-replicator/bin/replicator start offline
130发送端执行/home/kingbase/flysync/flysync/flysync-replicator/bin/replicator start offline
9.重置同步位置
129发送端执行/home/kingbase/flysync/flysync/flysync-replicator/bin/fsrepctl -service kstart reset -all -y
130目标端执行/home/kingbase/flysync/flysync/flysync-replicator/bin/fsrepctl -service kend reset -all -y
10.启动同步节点
129发送端执行/home/kingbase/flysync/flysync/flysync-replicator/bin/fsrepctl -service kstart online
130发送端执行/home/kingbase/flysync/flysync/flysync-replicator/bin/fsrepctl -service kend online