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 <[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/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]