Patroni高可用读写分离方案

一 机器和vip资源

PostgreSQL

pg1: 192.168.56.105

pg2: 192.168.56.106

etcd

etcd: 192.168.56.104

vip

读写vip: 192.168.56.111（请参考链接https://vip.kingdee.com/article/442624225686179840）

只读vip: 192.168.56.112

二 配置keepalived动态绑定只读vip

pg1和pg2实例上动态在从节点上绑定只读vip（192.168.56.112），当从节点故障时会将只读vip绑定在主节点上。

pg1和pg2实例上部署keepalived

yum install -y keepalived

配置keepalived参数文件

[root@localhost ~]# cat /etc/keepalived/keepalived.conf

global_defs {

    router_id LVS_DEVEL

}

vrrp_script check_leader {

    script "/usr/bin/curl -s http://127.0.0.1:8000/leader -v 2>&1|grep '200 OK' >/dev/null"

    interval 2

    weight 10

}

vrrp_script check_replica {

    script "/usr/bin/curl -s http://127.0.0.1:8000/replica -v 2>&1|grep '200 OK' >/dev/null"

    interval 2

    weight 5

}

vrrp_script check_can_read {

    script "/usr/bin/curl -s http://127.0.0.1