replication

[Si Chen]

Hello everyone.

Are there any recommended ways for doing postgresql replication?

Si Chen


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Joshua D. Drake]

Re: replication

Hello,

The two main replication products available are:

Slony-I and Mammoth Replicator.

Slony-I: Open Source, trigger based, batch replication.

Mammoth Replicator: Closed Source (source license available), integrated
(no triggers), live and batch replication.

They are both good solutions (I work for the creators of Mammoth
Replicator) that serve different purposes.

Sincerely,

Joshua D. Drake


Si Chen wrote:[color=blue]
> Hello everyone.
>
> Are there any recommended ways for doing postgresql replication?
> Si Chen
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org[/color]


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandpromp t.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Marc G. Fournier]

Re: replication

On Fri, 6 Aug 2004, Joshua D. Drake wrote:
[color=blue]
> Hello,
>
> The two main replication products available are:
>
> Slony-I and Mammoth Replicator.
>
> Slony-I: Open Source, trigger based, batch replication.
>
> Mammoth Replicator: Closed Source (source license available), integrated (no
> triggers), live and batch replication.
>
> They are both good solutions (I work for the creators of Mammoth Replicator)
> that serve different purposes.[/color]

eRServer is deployed in over a half dozen commercial enterprises, in
several cases doing replication across WANs ... so there are actually
three "main" ones ...

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postg resql.org so that your
message can get through to the mailing list cleanly

[Jan Wieck]

Re: replication

On 8/6/2004 1:55 PM, Joshua D. Drake wrote:[color=blue]
> Hello,
>
> The two main replication products available are:
>
> Slony-I and Mammoth Replicator.
>
> Slony-I: Open Source, trigger based, batch replication.
>
> Mammoth Replicator: Closed Source (source license available), integrated
> (no triggers), live and batch replication.[/color]

Out of curiosity, what is the difference between live and batch
replication?

Slony-I has shown recently that it can achieve replication lags down to
a second average, with sporadic spikes up to several seconds on packet
loss in a WAN setup. That was replicating to a virtual machine running
on a notebook and the DB connections ssh-tunneled over two wireless
links and the internet ... not exactly what one would call a production
grade network connection. The server was running a TPC-W ordering mix at
that time, processing about 60,000 transactions per hour resulting in
15,000 row updates per hour (the PHP session data was DB-based and
replicated too). A 10 hour fallback of the replica (the slave system was
moved from Philadelphia to Toronto and back a weekend later :-) ) was
cought up in 3 hours against the continuously running main server over
the WAN, and in about 1.5 hours back in the WLan.
[color=blue]
>
> They are both good solutions (I work for the creators of Mammoth
> Replicator) that serve different purposes.[/color]

Right (and I am the initial creator of Slony-I). Slony-I as a pure
trigger based approach for example does not aim at fully automatic DDL
replication.


Jan

--
#============== =============== =============== =============== ===========#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#============== =============== =============== ====== JanWieck@Yahoo. com #

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postg resql.org so that your
message can get through to the mailing list cleanly

[Vivek Khera]

Re: replication

>>>>> "JDD" == Joshua D Drake <jd@commandprom pt.com> writes:

JDD> Mammoth Replicator: Closed Source (source license available),
JDD> integrated (no triggers), live and batch replication.

Also, limited platform availability for Mammoth (ie, no FreeBSD
solution.)


--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.c om Rockville, MD +1-301-869-4449 x806
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings