Andrew Sullivan ajs
Wed Sep 27 10:58:44 PDT 2006
On Wed, Sep 27, 2006 at 10:13:23AM -0300, Marco Aurelio V. da Silva wrote:
> for not having an Internet of high availability in each server, it exists
> the necessity of if working in such a way, having one bd to master in each
> server and 3 bd?s slave. Slony is ideal for this scene?

As long as only one server is read-write on a given table, you're in
good shape.  Note that this four-by-four replication will require a
_lot_ of slon processes, so you're going to need to make sure you
have the horsepower for it.

> 
> other doubt,
> in each server, I execute a process slon to send the data and other to
> receive, after to execute the process to receive if the server responsavel

You need one slon per database-target combination.  I'm not sure I'm
understanding your question correctly, but it sounds like you think
you need something like this:

Database <-> slon <-> slon <-> database

That's not how it works.  It's 

Database <-> slon <-> database

A

-- 
Andrew Sullivan  | ajs at crankycanuck.ca
In the future this spectacle of the middle classes shocking the avant-
garde will probably become the textbook definition of Postmodernism. 
                --Brad Holland



More information about the Slony1-general mailing list