On 12/6/2010 8:09 AM, Sebastien Marchand wrote:
> Hi,
>
> I must replicate 2 servers ( A -> B )
>
> But not 2 databases but 1 database with 2 schemas ^^
>
> In one database DB1 with schemas S1 and S2, S1 from server A to server B
> ans S2 from server B to server A.
>
> Server A Server B
>
> DB1 DB1
>
> S1------------------------->S1
>
> S2<------------------------S2
>
> I can to that, but i can’t add a table in the futur L
>
> It’s possible or not to do that ?

You would build two replication sets. Set one originating on server A 
and subscribed by server B, set two originating on server B and 
subscribed by server A. Like Vick said, as long as you don't need 
partial table replication, you'll be fine.

Adding tables later works the same as if you had just one origin. You 
need to create a temporary set that you add those tables to, subscribe 
it to the same nodes that are subscribed to the existing set and when 
those subscriptions are complete, you merge the sets together.


Jan

-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin