[afnog] NEED HELP

Phil Regnauld regnauld at nsrc.org
Thu Feb 28 10:36:15 UTC 2013


Johan Bernhardsson (johan) writes:
> Application was openerp :)

	D'oh! :) More coffee.

But yes a master <-> master replication
> is needed and I'm quite unsure on how postgresql (that openerp uses
> as backend database) handles that. I don't think it will do so out
> of the box.

	Bucardo for Pg can do it, otherwise run M->S and flip that around
	when restoring the master node:

	http://www.postgresql.org/docs/9.1/static/high-availability.html

> Best way would to do a setup with kvm/libvirt and migrate a virtual
> host on failure.

	Correct - and with Ganeti, the high availability is free, as the
	VMs can be created with DRBD backing and failover just happens.

	Cheers,
	Phil



More information about the afnog mailing list