Re: Replication from 2 Master

2003-08-25 Thread Jeremy Zawodny
On Sun, Aug 24, 2003 at 02:45:01PM -0400, Eric Frazier wrote: > Hi, > > That makes a lot of sense, in fact we are using two servers as > "Masters" replicating to each other in a circle, but one has an > extra slave which is in our office. So in effect that does what this > guy was looking for, wit

Re: Replication from 2 Master

2003-08-25 Thread Eric Frazier
Hi, That makes a lot of sense, in fact we are using two servers as "Masters" replicating to each other in a circle, but one has an extra slave which is in our office. So in effect that does what this guy was looking for, without doing anything weird and strange. Thanks, Eric At 02:42 PM 8/2

Re: Replication from 2 Master

2003-08-24 Thread Jeremy Zawodny
On Sun, Aug 24, 2003 at 02:02:06PM -0400, Eric Frazier wrote: > Sounds very biblical. :) Yeah, I have it etched on a pair of stone tablets around here somewhere... :-) > Wouldn't there be a way to do this with two copies of mysql that > share a common data dir? Maybe. But that's not what he's

Re: Replication from 2 Master

2003-08-24 Thread Eric Frazier
Sounds very biblical. :) Wouldn't there be a way to do this with two copies of mysql that share a common data dir? I don't know if you could do that with InnoDB, but I wonder if you could with myisam? At least if you had a system where the two sets of tables came from a different master, and ther

Re: Replication from 2 Master

2003-08-24 Thread Jeremy Zawodny
On Sun, Aug 24, 2003 at 09:03:16PM +, [EMAIL PROTECTED] wrote: > Hi, > > I am running MySQL V4.0.14 with replication. > > > I want to replicate specified databases from 2 different masters into one > slave. Is this possible? No. A slave may only have one master. -- Jeremy D. Zawodny