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 678405E37D0 for ; Sat, 14 Aug 2004 13:31:04 -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 21251-10 for ; Sat, 14 Aug 2004 16:31:08 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 8B9DC5E3639 for ; Sat, 14 Aug 2004 13:31:00 -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 i7EGPjP08276; Sat, 14 Aug 2004 09:25:45 -0700 Message-ID: <411E3C3B.5060808@commandprompt.com> Date: Sat, 14 Aug 2004 09:22:19 -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: Jan Wieck Cc: Chris Cheston , pgsql-performance@postgresql.org Subject: Re: Replication: Slony-I vs. Mammoth Replicator vs. ? References: <411D6D47.5020203@commandprompt.com> <411E30C4.8020909@Yahoo.com> In-Reply-To: <411E30C4.8020909@Yahoo.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/229 X-Sequence-Number: 7865 > > Once again, Joshua, would you please explain what you mean with > "batch" and "live" replication system? Slony does group multiple > "master" transactions into one replication transaction to improve > performance (fewer commits on the slaves). The interval of these > groups is configurable and for high volume DBs it is recommended to > use about one second, which means that all commits that fall into an > interval of one second are replicated in one transaction on the slave. > On normal running systems this results in a replication lag of 600 to > 800 milliseconds in average. On overloaded systems the asynchronous > nature of course allows the slaves to fall behind. Your description above is what I considered batch... you are taking a "batch" of transactions and replicating them versus each transaction. I am not saying it is bad in any way. I am just saying it is different that replicator. > What is a usual average replication lag of Mammoth Replicator? > Obviously it depends on the system, the network connectivity between the systems etc... In our test systems it takes less than 100 ms to replicate the data. Again it depends on the size of the transaction (the data being moved). > What happens to the other existing slaves when you promote by hand? This is something that Slony has over replicator. Currently the new master will force a full dump to the slaves. Of course this is already on the road map, thanks to Slony :) and should be resolved by months end. > The Slony documentation is an issue at the moment and the > administrative tools around it are immature. The replication engine > itself exceeds my own expectations and performs very robust. > I have never suggested otherwise. My only comment about maturity is that their are actually many companies using replicator in production. We have already dealt with the 1.0 blues as they say. 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. Sincerely, Joshua D. Drake > > Jan > -- 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