docker-postgresql
docker-postgresql copied to clipboard
sameersbn
high availability
Hello! Is there a way in which I could configure these instances in ha? I need that if master crashes slave take his place.
at the moment there is no way to automatically switch. You need to do it manually.
I had one hardware crash about 2 weeks ago and I can't stop thinking about a multi-master setup.
Is it on your road map ?
Looks there is a few projects covering this feature like:
- https://2ndquadrant.com/en/resources/bdr/
- https://github.com/agios/docker-postgres-bdr
- https://wiki.postgresql.org/wiki/Postgres-XC
- https://github.com/postgres-x2/postgres-x2
Also, I want to thank you maintaining your projects and this one in particular. I'm running psql from your builds since about 4 months now and it's rock solid!
Cheers!
@sameersbn :I understand that we don't have automatically promote slave to master. But can we add guideline how to promote current slave to master?
@sameersbn - have you tried pgpool2 or something similar automatically balancing reads and writes? I am looking at https://github.com/jhunt/pgrouter and other similar tools to route / lb across the cluster based on your image.
