are there any issues replicating a database to a percona cluster?

[Mark Niel]

I have a database which I want to replicate to an InnoDB Cluster, and then failover the server to the InnoDB cluster. 

I was wondering if there are any issues replicating to an InnoDB cluster. 

The reason why I ask is I setup a MySQL to replicate to an InnoDB Cluster of 2 nodes (just for testing). 

I create a database and table on the Master, it replicates to cluster node1, and the same database and table appear on cluster node2. 

When I insert data on the Master, it goes to node1, but doesn't go to node2. 

When I insert data into node1, it goes into node2. 

It sort of makes me think the data is getting committed on node1, but not propagating to node2 when its done through replication. 

Would any problem cause this? Or is this a bug?

I am using Ubuntu 12.4 and the latest Percona download for it. 

Thanks!

Mark

[Alex Yurchenko]

Hi,

Check that you have set log_slave_updates.

Regards,
Alex

--
Alexey Yurchenko,
Codership Oy, www.codership.com
Skype: alexey.yurchenko, Phone: +358-400-516-011

[Mark Niel]

Thanks!

I thought it was something simple. 

I didn't think the cluster replication was connect to log_slave_updates, but I am sure I will find the notes somewhere that you have to do that. 

Works good. 

[Alex Yurchenko]

On 2012-10-26 03:18, Mark Niel wrote:
> Thanks!
> I thought it was something simple.
> I didn't think the cluster replication was connect to
> log_slave_updates,

Cluster replication is not connected to log_slave_updates, but
replicating slave updates (through cluster replication) does ;)

> but I am sure I will find the notes somewhere that you have to do
> that.
> Works good.
>
>
>> Check that you have set log_slave_updates.
>>
>> Regards,
>> Alex
>>
>> --
>> Alexey Yurchenko,
>>