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 <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: "rubn ruvalcaba" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> > > >To: Chuck Gadd <[EMAIL PROTECTED]> > >CC: rubn ruvalcaba <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > >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: 801-459-9582 > > > > > >-- > >MySQL General Mailing List > >For list archives: http://lists.mysql.com/mysql > >To unsubscribe: > >http://lists.mysql.com/[EMAIL PROTECTED] > > _________________________________________________________________ > 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: +49(0)221-470-7428 Fax: +49 (0) 221-470-7786 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/[EMAIL PROTECTED]
_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger: http://messenger.microsoft.com/es
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]