[Freeswitch-users] [OffTopic] Why PostgreSQL better then MySQL?

[Bzzz]

On Mon, 05 Nov 2012 08:32:54 -0500
Sergey Okhapkin <sos at sokhapkin.dyndns.org> wrote:

>  Does Postgres support circular multi-master replication like mysql does?

You have several solutions, depending whether you want sync (a bit of
weakness her) or async: PGCluster, Bucardo, Postgres-R, RubyRep...
(http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling)

EnterpriseDB is also presenting a solution (xDB), but it is in a beta state
though.

AFAIK, the most achieved sync project is Postgres-XC
(See http://postgres-xc.sourceforge.net/ &
http://en.wikipedia.org/wiki/Multi-master_replication#PostgreSQL) 
and Rubirep for async, (http://www.rubyrep.org/) - open-source speaking of
course, 'cos there are other (proprietary) solutions.

> Are 
> there some ways to run geographically distributed DB cluster?

As far as you can partition and sync replicate, you can do that with
Pg.

-- 
If it takes a bloodbath, lets get it over with.  No more appeasement.
		-- Ronald Reagan