Replications oddity.

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=gcdmg-mysql-2@m.gmane.org

Re: Replications oddity.

--0015177411469fee81047d30fee4
Content-Type: text/plain; charset=ISO-8859-1

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-s lave.html#option_mysqld_log-slave-updates

Thanks,
Krishna

On Fri, Jan 15, 2010 at 3:07 PM, Brent Clark 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=prajapatikc@gmail.com
>
>

--0015177411469fee81047d30fee4--

Re: Replications oddity.

On 15/01/2010 11:54, Krishna Chandra Prajapati wrote:
> 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-s lave.html#option_mysqld_log-slave-updates
>
> Thanks,
> Krishna
>

Thank you so much.

Works like a bomb.

-Brent

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org