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).
>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/
