人大金仓数据库V8R6主备集群手动创建流复制

两个单机搭建流复制

1、主机data/kingbase.conf添加：

wal_level = replica # minimal, replica, or logical

max_wal_senders = 10 # max number of walsender processes

wal_keep_segments = 512 # in logfile segments, 16MB each; 0 disables

max_replication_slots = 4

hot_standby = on

synchronous_standby_names='1(node2)'

2、主机修改sys_hba.conf文件

去掉最后注释，加上以下一行

host    replication     SYSTEM        备机IP/32            md5

3、备机拉取数据

sys_basebackup -U SYSTEM -h 主机IP -D /home/kingbase/cluster/KingbaseCluster/db/data -X stream -v -P

4、备机从template拷贝recovery.conf到data下，修改，内容如下

standby_mode='on'

primary_conninfo='port=54321 host=10.0.51.21 user=SYSTEM password=MTIzNDU2Cg== application_name=node2'

recovery_target_timeline='latest'

5、主机创建复制槽

select sys_create_physical_replication_slot('slot_node1');

select sys_create_physical_replication_slot('slot_node2');