VIP address for the replica database

[klaci71]

Hello,

Is there any way to attach vip address to an async replica database's server?

I couldn't find an etcd key, that contain exactly this information, but maybe it could be calculated from /scope/namespace/sync key. I have a leader, a sync standby and an async standby. If this key doesn't contain this node's name, then this node is async.

Thanks.

[pashagolub]

If you can put the proper trigger-key and trigger-value then probably it's doable

[klaci71]

Thank you, we will test it.

[klaci71]

Hello,

We tested it, but unfortunatelly didn't work well.
We hope, we did everything well. We downloaded the code from Github and exchanged the modified files, than compiled it.
We wrote these in the config.yml file:
trigger-key: "/asynchronous"
trigger-value: "200"
dcs-type: patroni # etcd, consul or patroni
dcs-endpoints:

• http://xxx.xxx.xxx.xxx:8008

At startup we catched this error messages:

2024-10-16T09:35:21.576779+02:00 my_nodename vip-manager[6584]: 2024/10/16 09:35:21 Using config from file: /var/lib/pgsql/vip-manager/vip-manager.yml
2024-10-16T09:35:21.576842+02:00 my_nodename vip-manager[6584]: 2024/10/16 09:35:21 This is the config that will be used:
2024-10-16T09:35:21.576860+02:00 my_nodename vip-manager[6584]: #011config : /var/lib/pgsql/vip-manager/vip-manager.yml
2024-10-16T09:35:21.576874+02:00 my_nodename vip-manager[6584]: #011dcs-endpoints : [http://xxx.xxx.xxx.xxx:8008]
2024-10-16T09:35:21.576890+02:00 my_nodename vip-manager[6584]: #011dcs-type : patroni
2024-10-16T09:35:21.576905+02:00 my_nodename vip-manager[6584]: #011hosting-type : basic
2024-10-16T09:35:21.576920+02:00 my_nodename vip-manager[6584]: #011hostingtype : basic
2024-10-16T09:35:21.576934+02:00 my_nodename vip-manager[6584]: #011interface : eth0
2024-10-16T09:35:21.576949+02:00 my_nodename vip-manager[6584]: #011interval : 1000
2024-10-16T09:35:21.576975+02:00 my_nodename vip-manager[6584]: #011ip : yyy.yyy.yyy.yyy
2024-10-16T09:35:21.576989+02:00 my_nodename vip-manager[6584]: #011manager-type : basic
2024-10-16T09:35:21.577004+02:00 my_nodename vip-manager[6584]: #011netmask : 24
2024-10-16T09:35:21.577020+02:00 my_nodename vip-manager[6584]: #011retry-after : 250
2024-10-16T09:35:21.577033+02:00 my_nodename vip-manager[6584]: #011retry-num : 3
2024-10-16T09:35:21.577049+02:00 my_nodename vip-manager[6584]: #011trigger-key : /asynchronous
2024-10-16T09:35:21.577066+02:00 my_nodename vip-manager[6584]: #011trigger-value : 200
2024-10-16T09:35:21.577087+02:00 my_nodename vip-manager[6584]: #011verbose : false
2024-10-16T09:35:21.577108+02:00 my_nodename vip-manager[6584]: #011version : false
2024-10-16T09:35:21.580267+02:00 my_nodename vip-manager[6584]: panic: runtime error: invalid memory address or nil pointer dereference
2024-10-16T09:35:21.580315+02:00 my_nodename vip-manager[6584]: [signal SIGSEGV: segmentation violation code=0x1 addr=0xe0 pc=0xb50701]
2024-10-16T09:35:21.580336+02:00 my_nodename vip-manager[6584]: goroutine 8 [running]:
2024-10-16T09:35:21.580376+02:00 my_nodename vip-manager[6584]: github.com/cybertec-postgresql/vip-manager/checker.(*PatroniLeaderChecker).GetChangeNotificationStream(0xc000071408, {0xe6eb10, 0xc000037130}, 0xc00009c460)
2024-10-16T09:35:21.580392+02:00 my_nodename vip-manager[6584]: #11/tmp/vip-manager-master/checker/patroni_leader_checker.go:32 +0x61
2024-10-16T09:35:21.580407+02:00 my_nodename vip-manager[6584]: main.main.func2()
2024-10-16T09:35:21.580428+02:00 my_nodename vip-manager[6584]: #11/tmp/vip-manager-master/main.go:101 +0x35
2024-10-16T09:35:21.580445+02:00 my_nodename vip-manager[6584]: created by main.main in goroutine 1
2024-10-16T09:35:21.580460+02:00 my_nodename vip-manager[6584]: #11/tmp/vip-manager-master/main.go:100 +0x525

The OS is SLES 15 SP3.

[pashagolub]

Thanks for pointing this out! Fix is available. Should work like a charm now :)

[klaci71]

Hello,
This version is works well.
Two vip-manager services run simultaneously, one manages the leader's VIP address from etcd, the other one handles the async replica's from Patroni.
Thank you very much for your help!