High availabitlty implementation in non-shared architecture

PostgreSQL
1

Hello.
I`m looking for information about tools to implement high availabily in PostgreSQL using 2 totally separeted servers.
Is Percona that sollution?

Thanks.

1 Like
2

Hi,

The Percona distribution of PostgreSQL already comes with Patroni. Otherwise, I’d need a little more information when you ask to implement High Availability.

Are you trying to setup a 2 node replication cluster (master-slave)?

1 Like
3

Hey @Robert_Bernier
I’m trying to setup postgresql geo-redundancy in non-shared architecture.Can you guide me on this?

4

Hi Suyash,

I’m trying to setup postgresql geo-redundancy in non-shared architecture.Can you guide me on this?

If there’s not too much detail involved probably I can help a bit.
Tell me a little about the system.

5

Hi Robert,

There are two single node kubernetes clusters on which i’m trying to setup postgresql geo-redundancy using patroni.

one of them will be primary and other will be standby.

my basic requirement is automatic Switchover on failure.

6

Since you are using K8s, I assume you are using the Percona Postgres K8s Operator?

7

yes, we are using percona postgres k8s operator.

8

Hi Suyash

Replication across Kubernetes clusters is possible through cascading replication. The setup process for setting this up for the Percona Operator for PostgreSQL is described at Deploy standby cluster based on streaming replication - Percona Operator for PostgreSQL

1 Like