X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A062E5E46D4 for ; Sat, 14 Aug 2004 21:58:32 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30217-02 for ; Sun, 15 Aug 2004 00:58:30 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 096215E46BF for ; Sat, 14 Aug 2004 21:58:28 -0300 (ADT) Received: from commandprompt.com (clbb-248.saw.net [64.146.135.248]) (authenticated) by hosting.commandprompt.com (8.11.6/8.11.6) with ESMTP id i7F0wVP24448; Sat, 14 Aug 2004 17:58:31 -0700 Message-ID: <411EB469.6020406@commandprompt.com> Date: Sat, 14 Aug 2004 17:55:05 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Christopher Browne Cc: pgsql-performance@postgresql.org Subject: Re: Replication: Slony-I vs. Mammoth Replicator vs. ? References: <411D6D47.5020203@commandprompt.com> <411E30C4.8020909@Yahoo.com> <411E3C3B.5060808@commandprompt.com> In-Reply-To: Content-Type: multipart/alternative; boundary="------------040508050809090200040805" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=HTML_MESSAGE, HTML_TITLE_EMPTY X-Spam-Level: X-Archive-Number: 200408/233 X-Sequence-Number: 7869 This is a multi-part message in MIME format. --------------040508050809090200040805 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Christopher Browne wrote: >Centuries ago, Nostradamus foresaw when jd@commandprompt.com ("Joshua D. Drake") would write: > > >>I hope you understand that I, in no way have ever suggested >>(purposely) anything negative about Slony. Only that I believe they >>serve different technical solutions. >> >> > >Stipulating that I may have some bias ;-), I still don't find it at >all clear what the different situations are "shaped like" that lead to >Mammoth being forcibly preferable to Slony-I. > > I would choose replicator if: 1. You want ease of setup 2. You want your each transaction to be replicated at time of commit 3. Your database is already laden with triggers 4. You are pushing a very high transactional load* * Caveat I have no idea how well Slony performs on a system that does say 200,000 transactions an hours that are heavily geared toward updates. Replicator performs very well in this scenario. 5. Replicators administrative tools are more mature than Slony (for example you know exactly what state your slaves are in with Replicator). I would choose Slony if: 1. The fact that it is Open Source matters to you 2. The auto promotion of slaves is important* *This will be fixed in a couple of weeks with Replicator To be fair, in the real world --- It doesn't make a bit of difference which one you choose it really comes down to this: Replicator is dumb simple to setup. Any halfway talented person can setup replicator in 30 minutes with a single master / slave configuration. Slony is Open Source and thus a little easier on the pocket book initially. Command Prompt, will support either one -- so the Replicator is commercially supported argument is a little weak here. Sincerely, Joshua D. Drake Sincerely, Joshua D. Drake >(Note that I have a pretty decent understanding about how ERS and >Slony work, so I'm not too frightened of technicalities... I set up >instances of both on Thursday, so I'm pretty up to speed :-).) > >Win32 support may be true at the moment, although I have to discount >that as we only just got the start of a beta release of native Win32 >support for PostgreSQL proper. For that very reason, I had to point >my youngest brother who needed "something better than Access" to >Firebird last Saturday; I played with my niece while he was doing the >install. And there is little reason to think that Slony-I won't be >portable to Win32 given a little interest and effort, particularly >once work to make it play well with "pgxs" gets done. > > -- 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 PostgreSQL Replicator -- production quality replication for PostgreSQL --------------040508050809090200040805 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Christopher Browne wrote:
Centuries ago, Nostradamus foresaw when jd@commandprompt.com ("Joshua D. Drake") would write:
  
I hope you understand that I, in no way have ever suggested
(purposely) anything negative about Slony. Only that I believe they
serve different technical solutions.
    

Stipulating that I may have some bias ;-), I still don't find it at
all clear what the different situations are "shaped like" that lead to
Mammoth being forcibly preferable to Slony-I.
  
I would choose replicator if:

1. You want ease of setup
2. You want your each transaction to be replicated at time of commit
3. Your database is already laden with triggers
4. You are pushing a very high transactional load*

* Caveat I have no idea how well Slony performs on a system that does say 200,000 transactions
an hours that are heavily geared toward updates. Replicator performs very well in this scenario.

5. Replicators administrative tools are more mature than Slony (for example you know exactly what state your slaves are in with Replicator).

I would choose Slony if:

1. The fact that it is Open Source matters to you
2. The auto promotion of slaves is important*

*This will be fixed in a couple of weeks with Replicator

To be fair, in the real world ---

It doesn't make a bit of difference which one you choose it really comes down to this:

Replicator is dumb simple to setup. Any halfway talented person can setup replicator
in 30 minutes with a single master / slave configuration.

Slony is Open Source and thus a little easier on the pocket book initially.

Command Prompt, will support either one -- so the Replicator is commercially supported
argument is a little weak here.

Sincerely,

Joshua D. Drake




Sincerely,

Joshua D. Drake




(Note that I have a pretty decent understanding about how ERS and
Slony work, so I'm not too frightened of technicalities...  I set up
instances of both on Thursday, so I'm pretty up to speed :-).)

Win32 support may be true at the moment, although I have to discount
that as we only just got the start of a beta release of native Win32
support for PostgreSQL proper.  For that very reason, I had to point
my youngest brother who needed "something better than Access" to
Firebird last Saturday; I played with my niece while he was doing the
install.  And there is little reason to think that Slony-I won't be
portable to Win32 given a little interest and effort, particularly
once work to make it play well with "pgxs" gets done.
  


-- 
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
PostgreSQL Replicator -- production quality replication for PostgreSQL
--------------040508050809090200040805--