特性描述: 主机通过发送日志给备机实现同步,备机通过发送日志给级联备实现同步,其中主备之间日志同步可配置为同步或异步,备机与级联备之间只能以异步方式。
目前一主多备方式架构,主机通过walsender线程向备机同步日志,备机通过walreceiver线程接受日志,并刷到本地盘,备机读取redo日志,完成主备之间的数据同步。主备机之间walsender与walreceiver一一对应。备机与级联备通过walsender与walreceiver线程异步方式同步日志,降低主机流复制的压力。
特性约束:
请参考 Mogdb 1主2备部署 进行搭建
在主库查看集群状态,显示为1主2备,其中192.168.11.6是同步备,192.168.11.7是异步备
$ gs_ctl query -D /dbdata/data
[2022-05-19 16:14:16.972][5954][][gs_ctl]: gs_ctl query ,datadir is /dbdata/data
HA state:
local_role : Primary
static_connections : 2
db_state : Normal
detail_information : Normal
Senders info:
sender_pid : 26582
local_role : Primary
peer_role : Standby
peer_state : Normal
state : Streaming
sender_sent_location : 0/50126A0
sender_write_location : 0/50126A0
sender_flush_location : 0/50126A0
sender_replay_location : 0/50126A0
receiver_received_location : 0/50126A0
receiver_write_location : 0/50126A0
receiver_flush_location : 0/50126A0
receiver_replay_location : 0/50126A0
sync_percent : 100%
sync_state : Sync
sync_priority : 1
sync_most_available : Off
channel : 192.168.11.5:51001-->192.168.11.6:43856
sender_pid : 28196
local_role : Primary
peer_role : Standby
peer_state : Normal
state : Streaming
sender_sent_location : 0/50126A0