Hi Brent, I believe you missed log_slave_updates component on 2 and 1. You have to enable binary logs + log_slave_updates on 2 and 1.
http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave-updates Thanks, Krishna On Fri, Jan 15, 2010 at 3:07 PM, Brent Clark <brentgclarkl...@gmail.com>wrote: > Hiya > > I have four servers. > > 1 < - > 2 > | | > 4 5 > > I have master - master replication working flawlessly between server id 1 > and 2. > Server id 4 is a slave of 1. > Server id 2 is a slave of 2. > > For the slaves replications it works great, but ... I just realised ... if > I create a database on id 1, it replicates to 2 and to 4, but does not > replicate to 5. And its the same if do it the inverse i.e. > Create a DB on 2, replication works to 1 and 5, but not to 4. > > Am I doing something wrong. Or am I misunderstanding how the process works. > I could make id 5 replicate from one., but I was hoping to make it off 2. > > If anyone could help me understand this, it would gratefully be > appreciated. > > Kind Regards > Brent > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com > >