Re: suggestions/hints for multimaster solution

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Jan 9, 2009 at 11:32 AM, Gerd König <koenig@xxxxxxxxxxxxxxx> wrote:
> Perhaps we should have a look at> * pg_pool(II)
I can only speak of pgpool-II. It's working fine for me in a setupwhich is exactly the same one you have (change OpenSuse for Debian,but the rest is the same). The thing is that pgpool-II itself canbecome a single point of failure unless you provide HA for it (I amdoing so with Heartbeat), but IMHO that would then be a failoversolution, not a multimaster (from pgpool-II's point of view, not thedatabases behind pgpool-II).
Next thing I want to do is try Slony-I with pgpool-II, but I thinkthat is not a multimaster solution either.
Of course we may have different points of view on what multimaster mean :)
If you plan on using pgpool-II, take into consideration thatreplication is done at a SQL query level, which is cool, but has itslimitations. If you use Slony-I inside pgpool-II I think you can takeover those limitations, but the solution is not so... neat, so tospeak :)
/discuss
-- Jaume Sabaterhttp://linuxsilo.net/
"Ubi sapientas ibi libertas"
-- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-admin

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux