3 ms·
Not 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.
by nodesocket 7y ago
Not 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.