cloudnative-pg / cloudnative-pg

CloudNativePG is a comprehensive platform designed to seamlessly manage PostgreSQL databases within Kubernetes environments, covering the entire operational lifecycle from initial deployment to ongoing maintenance
https://cloudnative-pg.io
Apache License 2.0
3.81k stars 261 forks source link

Switchovers for replica clusters #4678

Open gbartolini opened 1 month ago

gbartolini commented 1 month ago

A replica cluster is an independent cluster resource that is in replica from another Postgres instance, normally in another Kubernetes cluster in another region. They enable hybrid and multi-cloud setups, and can also be cascading.

Currently, a replica cluster and its origin are unrelated. Although they provide a solid yet simple architecture to achieve business continuity across regions, failovers and switchovers are entirely manual.

This feature aims at improving the switchover process, including the realignment of the previous primary.

gbartolini commented 1 month ago

Requires: