Zero-time downtime during failover

PostgreSQL Percona Operator for PostgreSQL
1

Does postgres operator support zero-time downtime during failover? In other terms, client’s connections should be preserved during switching from failed node to a new master.

1 Like
2

Hello @JuriM ,

right now it is not supported and during failover connections will be interrupted.

We are working on a design to have zero-downtime. Please share if you have a working example of such a deployment. We are at early stages of our implementation and might rethink the design.

1 Like
3

Hi,

We are using a similar approach https://github.com/gocardless/stolon-pgbouncer
Python script does pool pause/resume and master/standby switching on pgbouncer side.

1 Like
4

Thanks for sharing!

@Slava_Sarzhan @Charly_Batista any thoughts on this approach?

1 Like