Re: Does Single master and multimaster replication mix?
From: Frank van Bortel <fbortel_at_home.nl>
Date: Thu, 20 Dec 2001 20:58:28 +0100
Message-ID: <3C2242E4.D22C171F_at_home.nl>
Date: Thu, 20 Dec 2001 20:58:28 +0100
Message-ID: <3C2242E4.D22C171F_at_home.nl>
Si wrote:
>
> Can I set up a system of 4 databases, one master and three replicated
> slaves,
Yes - no problem
> in single Master config to maintain sync?
Eeh? Single Master Config? You only defined a single master in the line
above?
Not clear what this addition is meant for.
> And within each of these
> DB's, have one 'user table', for monitoring who is logged onto what, which
> is Multimaster and updates the remaining three when necessary?
No - that would be Multi-Master replication.
>
> Thanks in advance
>
No problem.
Would are you trying to accomplish anyway? Replication of a single table
could be done simpler, by means of custom triggers via dblinks (which
you'll
need anyway)
-- Gtrz, Frank van BortelReceived on Thu Dec 20 2001 - 20:58:28 CET