人大金仓KFS 8-8手动配置同步

本文详细描述了如何通过命令行方式在两台机器上配置KingbaseFlySync进行8.6版本的数据库同步,涉及数据库参数调整、环境设置、文件复制、同步配置和启动流程等关键步骤。
摘要由CSDN通过智能技术生成

命令行集中部署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

  • 6
    点赞
  • 8
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值