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]