Scott Marlowe wrote:
On Jan 19, 2008 6:14 PM, Gordan Bobic <gordan@xxxxxxxxxx> wrote:
Gregory Youngblood wrote:
On Sat, 2008-01-19 at 23:46 +0000, Gordan Bobic wrote:
David Fetter wrote:
In that case, use one of the existing solutions. They're all way
easier than re-inventing the wheel.
Existing solutions can't handle multiple masters. MySQL can do it at
least in a ring arrangement.
What about pgcluster? It's supposed to be able to provide synchronous
multi-master replication for postgresql.
I looked at that, too, but it wasn't really a "cluster of equal peers"
sort of solution, which is what I am after. Still, thanks for pointing
it out.
Oh, and there's this too:
Cybertec sync-multi-master
http://www.postgresql.org/about/news.752
http://www.postgresql.org/about/news.752
The design of that seems suspiciously similar to pgcluster with separate
load balancer and replicator servers.
Gordan
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend