3 ms·
Is there a Galera-equivalent system available of Postgres? I.e., multi-master replication. I know of BDR, but that doesn't seem to be publicly available for re
by throw0101a 7y ago
Is there a Galera-equivalent system available of Postgres? I.e., multi-master replication.
I know of BDR, but that doesn't seem to be publicly available for recent versions of Pg?
- nodesocket 7y agoNot sure about master-master, but I've used repmgr[1] to manage a PostgreSQL master-slave setup and it works pretty well though it is by no-means plug and play. There are a variety of steps and manual processes to get it up and running. [1] https://repmgr.org/ https://repmgr.org/
- throw0101a 7y agoWe find it handy to have multi-master, which leans towards being more active-active: we have keepalived doing health checks on two systems, and point our app server(s) at a vIP. The app server runs Galera's arbd so we don't need three DBs.
- exelib 7y agoIt's not a Postgres, but has a some limited Postgres dialect: CockroachDB. It has a range-based master-slave replication with routing and therefore you can use it instead of master-master replicated solutions. Be aware of high latency of distributed databases.