Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Multiple sync replicas #1565

Open
jamessewell opened this issue May 29, 2020 · 1 comment
Open

Multiple sync replicas #1565

jamessewell opened this issue May 29, 2020 · 1 comment

Comments

@jamessewell
Copy link
Contributor

From what I can gather patroni still supports one sync replica. I have a situation where would like to deploy to k8s cluster which has a controlplane spanning data centres. I need to guarantee zero data loss when a DC is lost.

Ideally I would have one three databases per DC with a sync replica at each site. Ideally a failover would prefer a local replica (although this isn’t a requirement).

Worst case just one sync replica at the other site. Obviously a failover complicates matters as if a DC was down just a single local replica would do.

Do I have any chance of making this work?

@CyberDem0n
Copy link
Member

There is WiP patch #672 which implements quorum commit and allows having more than one sync replica, it will partially solve your issue. Unfortunately it doesn't provide a way to specify in which DC you would like to have sync replicas. So one should also make Patroni dc-aware and implement the ability to specify priorities.

I don't really have time for that, any contributions are welcomed.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants