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>


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 Bortel
Received on Thu Dec 20 2001 - 20:58:28 CET

Original text of this message