News for hackers. Stuff that matters.

A comment on Bi-Directional Replication for PostgreSQL v1.0. Parent comment

Re:Bi-Directional Replication for PostgreSQL v1.0 by rvanlaar on Friday August 12, 2016 @10:01AM (#12275673)
I use on it to keep my postgres data in sync in a high available setup. I host two nodes, each in a different DigitalOcean datacenters (AMS2 and AMS3).

It's fast enough to not notice delays for users. As in, have a user log in on host1, switch the user to host2 and the session is there.

Disclaimer, we're not write heavy and have around one hundred active users.

https://rvanlaar.github.io/Django-HA-presentation/#/

[ Parent | on HN ]
Re:Bi-Directional Replication for PostgreSQL v1.0 by eloycoto on Friday August 12, 2016 @10:03AM (#12275687)
you should create a new node. Less than 3 is a bit dangerous ;-)
[ Parent | on HN ]
Re:Bi-Directional Replication for PostgreSQL v1.0 by martinmarques on Saturday August 13, 2016 @02:48PM (#12282571)
Actually with two nodes, if one node goes down, you don't have a BDR cluster anymore ;-)
[ Parent | on HN ]