List:General Discussion« Previous MessageNext Message »
From:Stefan Kuhn Date:December 3 2003 5:01pm
Subject:Re: Replication
View as plain text  
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:	801-459-9582
> >
> >
> >--
> >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: +49(0)221-470-7428   Fax: +49 (0) 221-470-7786
My public PGP key is available at http://pgp.mit.edu

Thread
Replicationrubn ruvalcaba3 Dec
  • Re: ReplicationChuck Gadd3 Dec
    • Re: ReplicationLloyd Kvam3 Dec
  • group_concat() alternative for mysql < 4.1?Victor SpĂ„ng Arthursson12 Jan
Re: Replicationrubn ruvalcaba3 Dec
  • Re: ReplicationStefan Kuhn3 Dec
Re: Replicationrubn ruvalcaba5 Dec