pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jan Wieck <JanWieck@Yahoo.com>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: Chris Cheston <ccheston@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Replication: Slony-I vs. Mammoth Replicator vs. ?
Date: Sat, 14 Aug 2004 11:33:24 -0400
Message-ID: <411E30C4.8020909@Yahoo.com> (raw)
In-Reply-To: <411D6D47.5020203@commandprompt.com>
References: <e071108e0408131827f23ab9c@mail.gmail.com>
	<411D6D47.5020203@commandprompt.com>

On 8/13/2004 9:39 PM, Joshua D. Drake wrote:

> Chris Cheston wrote:
>> HI all, I'm trying to implement a highly-scalable, high-performance,
>> real-time database replication system to back-up my Postgres database
>> as data gets written.
>> 
>> So far, Mammoth Replicator is looking pretty good but it costs $1000+ .  
> 
> Yes but it includes 30 days of support and 12 months of upgrades/updates :)

The lead developer of Slony (me) is working for a company that has it 
deployed in production already and will move more mission critical 
systems to it very shortly. Guess what will be my top work priority if 
you spot a bug?

> 
> 
>> Has anyone tried Slony-I and other replication systems?  Slony-I is
>> pretty new so I'm a little unsure if it's ready for a prime-time
>> commercial system yet.
> 
> It really depends on your needs. They are both good systems. Slony-I is 
> a bit more of a beast to get up and running, and it is a batch 
> replication system that uses triggers. Once it is up and running it 
> works well though.
> 
> Mammoth Replicator is easy to setup and is integrated into PostgreSQL.
> However replicator is 1000+ and doesn't support promoting of slaves 
> automatically (you can do it by hand) like Slony does. Replicator is
> also live replication.

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.

What is a usual average replication lag of Mammoth Replicator?

What happens to the other existing slaves when you promote by hand? In 
Slony they accept the new master and continue replicating without the 
need of rebuilding from scratch. Slony has mechanisms to ensure the new 
master will be ahead or equal in the replication process at the time it 
takes over and allows client application updates.

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.


Jan

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



view thread (8+ messages)  latest in thread

Message-ID: <411E30C4.8020909@Yahoo.com>
Permalink:  ../411E30C4.8020909@Yahoo.com/
Also on:    postgresql.org/message-id/411E30C4.8020909@Yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: JanWieck@Yahoo.com, jd@commandprompt.com, ccheston@gmail.com
  Subject: Re: Replication: Slony-I vs. Mammoth Replicator vs. ?
  In-Reply-To: <411E30C4.8020909@Yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox