RE: RE: Multiple masters to 1 slave??

2002-07-02 Thread Orr, Steve
> A slave can only have one master. You obviously don't work around here. :-) -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Subject: Re: Multiple masters to 1 slave?? On Tue, Jul 02, 2002 at 10:54:44AM -0500, Jim Crippen wrote: > > In the my.cnf f

Re: Multiple masters to 1 slave??

2002-07-02 Thread Jeremy Zawodny
On Tue, Jul 02, 2002 at 10:54:44AM -0500, Jim Crippen wrote: > > In the my.cnf file on the off-site slave, can there be multiple masters > specified where it will replicate all 3 in-house servers to different > databases on itself? No. A slave can only have one master. Jeremy -- Jeremy D. Za

Multiple masters to 1 slave??

2002-07-02 Thread Jim Crippen
I'm trying to find a way to set up an off-site replication (slave 3). In house I have several MySQL 4.0 servers that are using replication. They consist of 1 master (master1) for all data, 1 slave (slave 1) for optimized web access and 1 slave (slave 2) for the internal database app. Both slave