Thread: replication
Hello everyone. Are there any recommended ways for doing postgresql replication? Si Chen
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: > 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 -- 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@commandprompt.com - http://www.commandprompt.com Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
Attachment
On Fri, 6 Aug 2004, Joshua D. Drake wrote: > 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. 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
On 8/6/2004 1:55 PM, Joshua D. Drake wrote: > 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. 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. > > They are both good solutions (I work for the creators of Mammoth > Replicator) that serve different purposes. 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 #
>>>>> "JDD" == Joshua D Drake <jd@commandprompt.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.com Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/