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.
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
> >`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:
> 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