Re: Replication

[rubn ruvalcaba]

Stefan:

   Thank you very much, I got the point. I'll make some tests with the 
'log-slave-updates' parameter, I think if the master can log the updates 
made from any slave, then it can propagate the changes to the others.

   Regards


>From: Stefan Kuhn <stefan.kuhn@stripped>
>Reply-To: stefan.kuhn@stripped
>To: "rubn ruvalcaba" <rubenruvalcaba@stripped>, mysql@stripped
>Subject: Re: Replication
>Date: Wed, 3 Dec 2003 18:01:39 +0100
>
>Am Wednesday 03 December 2003 18:21 schrieb rubn ruvalcaba:
> > You guys are right, as Cuck said I need each machine acts as server and
> > slave, I did it with two servers in a circular replication and works 
>pretty
> > fine, but when add a third machine, there comes the problems, because 
>the
> > central server must be the master (no problem) and the slave of two 
>servers
> > (here is the problem).
>
>If you want to do a circular replication, it needs to be like this:
>A is slave of B
>B is slave of C
>C is slave of A
>Important: You need to set log-slave-updates in my.cnf, so that B logs what 
>it
>gets from C and A gets it then from B.
>I have such a configuration in production use and all works fine.
>Stefan
>P. S: Note your two server configuration is just a special case of this.
>
> >
> > From: Lloyd Kvam <pythontutor@stripped>
> >
> > >To: Chuck Gadd <cgadd@stripped>
> > >CC: rubn ruvalcaba <rubenruvalcaba@stripped>,
> mysql@stripped
> > >Subject: Re: Replication
> > >Date: Wed, 03 Dec 2003 09:59:29 -0500
> > >
> > >You can setup a circular replication stream.  Make sure that the
> > >replicated data gets written to the output binlogs.  From the
> > >manual:
> > >
> > >`log-slave-updates'     Tells the slave to log the updates from the
> > >                        slave thread to the binary log. Off by default.
> > >                        You will need to turn it on if you plan to
> > >                        daisy-chain the slaves.
> > >
> > >Chuck Gadd wrote:
> > >>rubn ruvalcaba wrote:
> > >>>I want to know how could solve the next replication scenario:
> > >>>
> > >>>I have a master.
> > >>>I have 5 slaves.
> > >>>
> > >>>At start the slaves has a master snapshot.
> > >>>
> > >>>Now imagine slave 1, inserts a record. When it gets connected to
> the
> > >>> lan, it must replicate it's changes to the master.
> > >>
> > >>No, a slave receives changes that occur at the master.   That's
> > >>why it's a slave.
> > >>
> > >>I suspect you want each machine to be a Master and a slave.
> > >
> > >--
> > >Lloyd Kvam
> > >Venix Corp.
> > >1 Court Street, Suite 378
> > >Lebanon, NH 03766-1358
> > >
> > >voice:	603-653-8139
> > >fax:	[phone]
> > >
> > >
> > >--
> > >MySQL General Mailing List
> > >For list archives: http://lists.mysql.com/mysql
> > >To unsubscribe:
> > >http://lists.mysql.com/mysql?unsub=1
> >
> > _________________________________________________________________
> > MSN. Más Útil Cada Día  http://www.msn.es/intmap/
>
>--
>Stefan Kuhn M. A.
>Cologne University BioInformatics Center (http://www.cubic.uni-koeln.de)
>Zülpicher Str. 47, 50674 Cologne
>Tel: [phone]   Fax: [phone]
>My public PGP key is available at http://pgp.mit.edu
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    
>http://lists.mysql.com/mysql?unsub=1
>

_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger:  
http://messenger.microsoft.com/es