[Pgpool-general] which is advantage of master/slave mode vsreplication on pgpool-II

[Daniel.Crespo at l-3com.com]

In addition to that, I would say that first of all, you need to know
what you need: Synchronous replication or Asynchronous replication.

Slony-I is Asynchronous

Pgpool-II is Synchronous

You should not compare Slony-I vs Pgpool-II.

 

Daniel

 

From: pgpool-general-bounces at pgfoundry.org
[mailto:pgpool-general-bounces at pgfoundry.org] On Behalf Of Steven
Crandell
Sent: Thursday, January 07, 2010 3:18 PM
To: erobles
Cc: pgpool
Subject: Re: [Pgpool-general] which is advantage of master/slave mode
vsreplication on pgpool-II

 

The details of master/slave vs replication modes are detailed pretty
well here:
http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html

 

In general, master/slave mode assumes that there is some other
replication software involved replicating data from the master to the
slaves (slony, mammoth, etc)

Replication mode means that pgpool will take care of the replication
itself.

 

I'm a big fan of the mammoth replication system so the advantage of
master/slave replication mode for me is that I can use pgpool to load
balance my queries while still counting on mammoth to handle my
replication.  I haven't use pgpool in replication mode so I can't speak
to any strengths or weaknesses there.  It basically comes down to apples
vs. oranges.  It's two completely different methods to accomplish
basically the same thing.

 

-s

On Thu, Jan 7, 2010 at 9:15 AM, erobles <erobles at sensacd.com.mx> wrote:

hi!
like the subjects said, i am interesting on the advantages  of pgpool
in  master/slave mode over replication mode


regards!
_______________________________________________
Pgpool-general mailing list
Pgpool-general at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20100107/0508e58a/attachment.html>